Tuesday, October 28, 2014

Select top 1 record from a table which has duplicates - Please help!


;With cte As
(Select ID, DeptId, Marks,
Row_Number() Over(Partition By ID Order By Marks Desc) As rn
From #Student)
Select ID, DeptId, Marks
From cte
Where rn = 1
Order By ID;



Tom

No comments:

Post a Comment