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:

snippet

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:

Example1:

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

snippet

SELECT * FROM STUDENT ORDER BY FEES ASC;

Output:

Example2:

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

snippet

SELECT * FROM STUDENT ORDER BY NAME, FEES DESC;

Output:

Related Tutorial

1 SQLite WHERE Clause

2 SQLite AND Operator

3 SQLite OR Operator

4 SQLite LIKE Clause (Operator)

5 SQLite GLOB Clause (Operator)

6 SQLite LIMIT Clause

7 SQLite ORDER BY Clause

8 SQLite GROUP BY Clause

9 SQLite HAVING Clause

10 SQLite DISTINCT Clause

11 SQLite Union Operator

12 SQLite Union All Operator

Try it

Contents +