issue with unique selection

[SqlHunter]

Here I have a set of data and I need to export these dataset from excel to sql server table.Here When I need to select only unique emp_id with maximum exam_id but even when I use the distinct its populating the second one



-------------------------------------------------------------------------------- Emp_id exam_id Grade_obtained
0001002492 1903956 Grade B
0001002492 1903956
0001002492 1903956 Grade A
0001049121 1963794 Grade B
1963344 Grade C
1963444 Grade D

 

[dbomrrsm]

SELECT Emp_Id, max(exam_id),Grade_Obtained
FROM YourTable
Group By Emp_Id

[blue]DBomrrsm[/blue]