SOQL ORDER BY
ORDER BY clause is used to sort the returned rows in the specified order. We can sort ascending or descending by specifying
If we do not specify anything, ascending order is used. We con sort multiple fields at the same time, and the sorting order is left to right.
We can sort text, number, date, datetime and text fields.
Example #1: Find all the clinics in descending order of their name.
Example #2: Find all the clinics in various states and cities and sort them first by states, and then by cities.
You can also sort based on an aggregated field in
GROUP BY clause.
Example #3: Find the clinics and their total booking amount in the previous month. Sort the results in descending order of the total booking amount.