Raj Ma

Greenhorn
+ Follow
since Mar 22, 2004
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Raj Ma

you try this..
SELECT * FROM
(SELECT STUDENT.*, DENSE_RANK() OVER(ORDER BY MARKS DESC) AS RK
FROM STUDENT)
WHERE RK <=5