Or this, depending of what you really want-- Prepare sample dataDECLARE @Sample TABLE (StudentID INT, TermID INT, CourseID INT)INSERT @SampleSELECT 1, 98, 40 UNION ALLSELECT 1, 99, 41 UNION ALLSELECT 1, 100, 43 UNION ALLSELECT 1, 102, 42 UNION ALLSELECT 1, 102, 45 UNION ALLSELECT 2, 100, 41 UNION ALLSELECT 2, 101, 42 UNION ALLSELECT 2, 101, 43 UNION ALLSELECT 2, 102, 44 UNION ALLSELECT 3, 97, 41 UNION ALLSELECT 3, 98, 42 UNION ALLSELECT 3, 102, 43 UNION ALLSELECT 3, 102, 54-- Show the expected outputSELECT DISTINCT StudentID, TermIDFROM ( SELECT StudentID, TermID, DENSE_RANK() OVER (PARTITION BY StudentID ORDER BY TermID DESC) AS RecID FROM @Sample ) AS dWHERE RecID = 2
E 12°55'05.25"N 56°04'39.16"