SQL ORDER BY Keyword

The ORDER BY keyword is used to sort the values in Ascending [ASC] or Descending [DESC] order. The default sorting in the ORDER BY keyword is in Ascending Order. To sort it in descending order, we need to add [DESC] with the keyword. With the keyword, we can add multiple columns

  • Syntax of ORDER BY keyword –

SELECT column1,column2,column3,...,columnN FROM table_name
ORDER BY column1,column2,....ASC|DESC;

Here in the syntax, we have Order By with multiple columns and the sorting can be done either in Ascending or Descending Order. To manage the sorting, it needed to add the keyword for ascending and descending.

Demo table –

Product Table 

Category Region City Country Customer_ID Customer_name
Office Supplies Central Chicago United States SM-20950 Suzanne McNair
Technology East New York City United States AH-10465 Amy Hunt
Office Supplies East New York City United States AH-10465 Amy Hunt
Office Supplies East Dover United States EP-13915 Emily Phan
Office Supplies East Dover United States EP-13915 Emily Phan
Technology West Aurora United States TP-21565 Tracy Poddar
Office Supplies West Aurora United States TP-21565 Tracy Poddar
Office Supplies East Long Beach United States AR-10825 Anthony Rawles
Office Supplies West Pasadena United States HA-14920 Helen Andreada
Furniture West Pasadena United States HA-14920 Helen Andreada

ORDER BY Single Column Example –

Consider the Product table of the Customer database and select Category, Region, City, Country, Customer ID, and Customer Name columns from the table, sort in  DESCENDING by the “City” column.

SELECT Category,Region,City,
[Country/Region],[Customer ID],[Customer Name]
FROM [dbo].[Products]
ORDER BY City DESC ;

 

The output after executing the above statement is as shown –

Category Region City Country Customer_ID Customer_name
Office Supplies West Pasadena United States HA-14920 Helen Andreada
Furniture West Pasadena United States HA-14920 Helen Andreada
Technology East New York City United States AH-10465 Amy Hunt
Office Supplies East New York City United States AH-10465 Amy Hunt
Office Supplies East Long Beach United States AR-10825 Anthony Rawles
Office Supplies East Dover United States EP-13915 Emily Phan
Office Supplies East Dover United States EP-13915 Emily Phan
Office Supplies Central Chicago United States SM-20950 Suzanne McNair
Technology West Aurora United States TP-21565 Tracy Poddar
Office Supplies West Aurora United States TP-21565 Tracy Poddar

In the output, the columns in the SELECT statement have been sorted in descending alphabetic order of City.

ORDER BY Multiple Columns Example –

Consider the Product table of the Customer database and select the Customers Name, Category, City, and Country columns from the table, sort them in DESCENDING by the “City” column and ASCENDING by the “Country/Region” column.

SELECT Category,Region,City,
[Country/Region],[Customer ID],[Customer Name]
FROM [dbo].[Products$]
ORDER BY City DESC , [Country/Region] ASC;

The output after executing the above statement is as shown –

Category Region City Country Customer_ID Customer_name
Office Supplies West Pasadena United States HA-14920 Helen Andreada
Furniture West Pasadena United States HA-14920 Helen Andreada
Technology East New York City United States AH-10465 Amy Hunt
Office Supplies East New York City United States AH-10465 Amy Hunt
Office Supplies East Long Beach United States AR-10825 Anthony Rawles
Office Supplies East Dover United States EP-13915 Emily Phan
Office Supplies East Dover United States EP-13915 Emily Phan
Office Supplies Central Chicago United States SM-20950 Suzanne McNair
Technology West Aurora United States TP-21565 Tracy Poddar
Office Supplies West Aurora United States TP-21565 Tracy Poddar

 

In the output, the columns in the SELECT statement have been sorted in descending alphabetic order of City, and then all the cities are sorted in ascending order of Country.

 

 

Follow us on TwitterFacebookLinkedin, and Tableau Public to stay updated with our latest blog and what’s new in Tableau.

Automate data analysis pipeline and create report ready dashboards

If you are looking forward to getting your data pipeline built and setting up the dashboard for business intelligence, book a call now from here.

#analytics #data #business #artificialintelligence #machinelearning #startup #deeplearning #deeplearning #datascience #ai #growth #dataanalytics #india #datascientist #powerbi #dataanalysis #tableau #SQL #businessanalytics #businessanalyst #businessandmanagement #dataanalyst #businessanalysis #analyst #analysis #powerbideveloper #powerbidesktop #letsviz