Get top records from sql query

you can make use of top clause in sql query

table:

id,name,score;

select top(2) *

from table

order by  score desc ;

above query will give the top 2 highest scorer.