Coginiti menu Coginiti menu

SQL Order by

What is the ORDER BY Clause in SQL?

The SQL ORDER BY clause sorts the results of a SELECT statement in either ascending or descending order based on one or more columns.

Here’s the syntax:

SELECT column1, column2, ... 
FROM table_name 
ORDER BY column1 [ASC|DESC], column2 [ASC|DESC], ...;

You can use “DESC” with the SQL ORDER BY to list the rows based on the column you choose. In this example, the data follows the descending order of the year launch.

FROM sandbox.tv_show  
ORDER BY year_launch DESC;

Order by desc

If you have text instead of a number, you can order alphabetically. To list from A-Z, use ASC as follows.

Order by asc

Note the “sandbox.” before the table name means the schema that holds the table in Coginiti.