How can we select top 20 rank students details in a given list?

Posted by Udaysimha under Interview Questions on 1/19/2012 | Points: 10 | Views : 733 | Status : [Member] | Replies : 1
Hi All,
Please give me the query to select top 20 rank students details in a given list.
Thanks

uday


Responses

Posted by: Blessyjees on: 1/19/2012 [Member] Bronze | Points: 25

Up
0
Down
Hi,
try like this
Select top 20 * from student order by totalmark desc

Blessy Baby
Digitalmesh Softech pvt Ltd
https://blessybaby.wordpress.com/

Udaysimha, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response