Select * from StudentAchievement A Where Exists(
select 1 from StudentAchievement
Where CourseID=A.CourseID And Achievement>A.Achievement
Having Count(*)<=1
)
Order by CourseID,Achievement Desc
select 1 from StudentAchievement
Where CourseID=A.CourseID And Achievement>A.Achievement
Having Count(*)<=1
)
Order by CourseID,Achievement Desc
Select *
From StudentAchievement a
Where StudentID in (Select Top 2 StudentID
From StudentAchievement
Where CourseID=a.CourseID
Order by Achievement desc)
order by CourseID,Achievement desc