python - sqlite3: select top n records in a column -


i've searched online , found how return top n records

select * tab1 limit 10;  

but want find top n records have highest values in column... syntax it? thank in advance.

select * tab1 order field desc limit 10; 

Comments