SQLite - ORDER BY Clause

In SQLite the ORDER BY clause can be used to sort the result based on more than one columns.

Using ORDER BY , data can be sorted eighther in ascending order or in descending order.

ASC : Sorts tha result set in ascending order.

DESC : Sorts tha result set in descending order..

Syntax: ORDER BY - ASC

SELECT column_1, column_2, column_n 
FROM table_name
WHERE [condition_1] 
[ORDER BY column_1, column_2, .. column_n] [ASC];

One or more columns can be used to sort the data.

Example:

So let's consider we have created SCHOOL database. And we have created a STUDENTS table in this database.

The STUDENTS table have five columns (ID, NAME, SURNAME, AGE, ADDRESS).

The STUDENTS table also have some data inside it as shown below:

ID          NAME        SURNAME     AGE         ADDRESS
----------  ----------  ----------  ----------  ----------
1           Mark        Osaka       20          Munich
2           Tom         white       21          Cologne 
3           Patric      Rossman     19          Essen
4           Mark        Khan        22          Bonn
5           Julia       Tesar       18          Berlin
6           Tim         Netten      20          Frankfurt
7           Mark        Mevric      17          Wuppertal

The following SQLite statement selects the columns from the STUDENTS table ORDER BY AGE in ascending order:

sqlite> SELECT * FROM STUDENTS ORDER BY AGE ASC;
ID          NAME        SURNAME     AGE         ADDRESS
----------  ----------  ----------  ----------  ----------
7           Mark        Mevric      17          Wuppertal
5           Julia       Tesar       18          Berlin
3           Patric      Rossman     19          Essen
1           Mark        Osaka       20          Munich
6           Tim         Netten      20          Frankfurt
2           Tom         white       21          Cologne 
4           Mark        Khan        22          Bonn

Syntax: ORDER BY - DESC

SELECT column_1, column_2, column_n 
FROM table_name
WHERE [condition_1] 
[ORDER BY column_1, column_2, .. column_n] [DESC];

Example:

The following SQLite statement selects the columns from the STUDENTS table ORDER BY AGE in descending order:

sqlite> SELECT * FROM STUDENTS ORDER BY AGE DESC;
ID          NAME        SURNAME     AGE         ADDRESS
----------  ----------  ----------  ----------  ----------
4           Mark        Khan        22          Bonn
2           Tom         white       21          Cologne 
6           Tim         Netten      20          Frankfurt
1           Mark        Osaka       20          Munich
3           Patric      Rossman     19          Essen
5           Julia       Tesar       18          Berlin
7           Mark        Mevric      17          Wuppertal

SqLite Tutorial

SqLite - HOME SqLite - Intro SqLite - Installation SqLite - Syntax SqLite - Data Types SqLite - Create DB SqLite - Create Table SqLite - Drop Table SqLite - Select SqLite - Distinct SqLite - Where SqLite - And & Or SqLite - Order By SqLite - Insert Into SqLite - Update SqLite - Delete SqLite - Injection SqLite - Select Top SqLite - Like SqLite - Wildcards SqLite - In SqLite - Between SqLite - Aliases SqLite - Joins SqLite - Inner Join SqLite - Left Join SqLite - Right Join SqLite - Full Join SqLite - Union SqLite - Select Into SqLite - Insert Into Select SqLite - Constraints SqLite - Not Null SqLite - Unique SqLite - Primary Key SqLite - Foreign Key SqLite - Check SqLite - Default SqLite - Create Index SqLite - Drop SqLite - Alter SqLite - Auto Increment SqLite - Views SqLite - Dates SqLite - Null Values SqLite - Null Functions SqLite - Data Types SqLite - DB Data Types

SqLite Functions

SqLite - Functions SqLite - Avg() SqLite - Count() SqLite - First() SqLite - Last() SqLite - Max() SqLite - Min() SqLite - Sum() SqLite - Group By SqLite - Having SqLite - Ucase() SqLite - Lcase() SqLite - Mid() SqLite - Len() SqLite - Round() SqLite - Now() SqLite - Format()