[Pottus]

Make sure the table type is numeric I've experienced this problem before you could probably also do this but not recommended.

pawn Код:

db_query(database, "SELECT `STAT` FROM `TABLE` WHERE `STAT` > '1' ORDER BY (`STAT` * '1') DESC");

At any rate if your using SQLite then using SQLitei is for you here is my recommended read overs for using SQLite with SAMP. SQLitei has query error reporting which is very useful for debugging queries (only works on Windows) technically you don't need to use any native features of SQLitei either to take advantage of some of the features. I will recommend you open your db's with this native.

pawn Код:

DB:db_open_persistent(name[])

https://sampforum.blast.hk/showthread.php?tid=449536 - Konstantinos tutorial
https://sampforum.blast.hk/showthread.php?tid=303682 - SQLitei