SQLite Order by Clause

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.

Syntax:

  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:

Sqlite Order by clause 1

Example1:

Select all records from “STUDENT” where FEES is in ascending order:

Output:

Sqlite Order by clause 2

Example2:

Fetch all data from the table “STUDENT” and sort the result in descending order by NAME and FEES:

Output:

Sqlite Order by clause 3