I have no idea what you are trying to achieve based on your example. Here is a stab at it though.DECLARE @table TABLE(ExamID INT, ExamTypeID INT)INSERT @table(ExamID, ExamTypeID) SELECT 1, 1 UNION ALL SELECT 2, 1 UNION ALL SELECT 3, 1 UNION ALL SELECT 4, 2 UNION ALL SELECT 5, 2 UNION ALL SELECT 6, 3 UNION ALL SELECT 7, 3 UNION ALL SELECT 8, 2SELECT ExamID, ExamTypeIDFROM @tableSELECT MIN(ExamID), ExamTypeIDFROM @tableGROUP BY ExamTypeID
MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA.