SQLite ORDER BY Clause
The SQLite ORDER BY clause is used to sort the fetched data in ascending or descending order, based on one or more column.
You can use one or more columns in ORDER BY clause. Your used column must be presented in column-list.
Let's take an example to demonstrate ORDER BY clause. We have a table named "STUDENT" having the following data:
Select all records from "STUDENT" where FEES is in ascending order:
Fetch all data from the table "STUDENT" and sort the result in descending order by NAME and FEES: