The SQLite ORDER BY clause is used to sort the fetched data in ascending or descending order, based on one or more column.
SELECT column-list FROM table_name [WHERE condition] [ORDER BY column1, column2, .. columnN] [ASC | DESC];
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:
SELECT * FROM STUDENT ORDER BY FEES ASC;
Fetch all data from the table "STUDENT" and sort the result in descending order by NAME and FEES:
SELECT * FROM STUDENT ORDER BY NAME, FEES DESC;