Monday, October 31, 2011

SQL QUERY TO FIND THE 5TH MAX MARK FROM EXAM TABLE


SELECT Top 1 MARK AS MARK FROM exam
WHERE MARK IN
(SELECT DISTINCT TOP(5) MARK FROM exam ORDER BY MARK DESC)
ORDER BY MARK
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)