So, I have this problem, I have this set of records in a table

and this repeated many times. My problem is that I have to take only the oldest record for each set of CastingID just like that:

I tried using DISTINCT and MIN functions, but I can't obtain the result I want, can you please help me or provide some examples?

CodePudding user response：

You can try this,

SELECT * 
FROM (
    SELECT 
        *
        , RANK() OVER (PARTITION BY CastingID ORDER BY TemperatureDateTime ASC) RN
    FROM TABLE_1
) A
WHERE RN = 1;