SQL: with ranked_table AS ( SELECT *, ROW_NUMBER() OVER (PARTITION BY ProductionLine_Number ORDER BY date_Time) AS rn FROM table1 ), filtered_table AS ( SELECT id, Cardboard_Number, date_Time, ...