Menu
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?
265
Multi-Level Data Sorting is the process of arranging the data of more than one column in ascending or descending order.
Combining multiple fields in one sort is called multilevel sorting. Multilevel sorting can help clarify search results while also increasing their accuracy.
If you need to change the order of a multilevel sort, it's easy to control which column is sorted first. Simply select the desired column, then click the Move Up or Move Down arrow to adjust its priority.
You could use e.g. ORDER BY rating DESC, name ASC to sort by rating and then, if the ratings are equal, by name.
122
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
