I have a table with some records with fields like name, rating etc.
I first want to sort based on rating limiting results to 20 and then on this resultset want to further apply sort based on name.
I know to sort we need to use the query like
"Select * from table order by rating Desc limit 20"
but on this resultset how to apply another level of ordering? How can i combine these two sorts in one sqlite statement?
How is this possible?
Rgds,
Sapan