Multiple level ordering
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?
You could use e.g. ORDER BY rating DESC, name ASC to sort by rating and then, if the ratings are equal, by name.
This query should do the trick:
SELECT * FROM (SELECT * FROM table ORDER BY rating DESC LIMIT 20) ORDER BY name