Javatpoint Logo
Javatpoint Logo

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:

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




Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


B.Tech / MCA