Using a database to generate a leaderboard

I have a database, inside this database I have a table and I would like to extract the top 25 people from a certain entry. I have this so far but I really would like some help or someone to tell me where to go from here:


sql.Query("select id, level FROM ( select id, player_level RANK() over(order by(player_level) desc) as level_rank from instructor where level_rank <=25")

I would then like to get the info, then send the id and level from all those players via a net message to clientside. I don’t expect anyone to write it for me, just an indication of where to go.

I’m pretty sure you can do this :



SELECT `thing`, `otherthing` FROM `table` ORDER BY `field` DESC/ASC LIMIT 25