SQL - How to get list, descending

[Hijirikawa]

So I want to list 10 players who are in the top level ranking ,however this code only checks for level 99s, how do I make it so that it can also check for levels that are not 99 yet?

query_sql( "SELECT `base_level` FROM `char` WHERE `base_level` = 99",.@acclvl );

Because I need the NPC to display first 10 players to reach level 99 and if there is still none, it will display the highest level'd players (up to 10)

[rongmauhong]

Hi, try this code
 

query_sql( "SELECT `char_id`,`name`,`base_level` FROM `char` ORDER BY `base_level` DESC LIMIT 10",.@cid[0],.@name$[0],.@level[0]);

 

[Hijirikawa]

Thanks! I will try it out and see what happens.