Shulou(Shulou.com)06/01 Report--

Editor to share with you how to use the ORDER BY clause in SQL. I hope you will get something after reading this article. Let's discuss it together.

SQL ORDER BY clause

The ORDER BY statement is used to sort the result set based on the specified column.

The ORDER BY statement sorts records in ascending order by default. To sort records in descending order, use the DESC keyword.

"Orders" table:

Company OrderNumberIBM 3532HuluMiao 2356Apple 4698IBM 6953

Example 1: display the company name in alphabetical order:

SELECT Company, OrderNumber FROM Orders ORDER BY Company

Results:

Company OrderNumberApple 4698HuluMiao 2356IBM 6953IBM 3532

Example 2: displays the company name (Company) in alphabetical order and the sequence number (OrderNumber) in numerical order:

SELECT Company, OrderNumber FROM Orders ORDER BY Company, OrderNumber

Results:

Company OrderNumberApple 4698HuluMiao 2356IBM 3532IBM 6953

Example 3: display the company name in reverse alphabetical order:

SELECT Company, OrderNumber FROM Orders ORDER BY Company DESC

Results:

Company OrderNumberIBM 6953IBM 3532HuluMiao 2356Apple 4698

Example 4: displays the company name in reverse alphabetical order and the sequence number in numerical order:

SELECT Company, OrderNumber FROM Orders ORDER BY Company DESC, OrderNumber ASC

Results:

Company OrderNumberIBM 3532IBM 6953HuluMiao 2356Apple 4698

Tip: in this example, when the first column has the same value (which can be nulls), the second column is arranged in ascending order.

After reading this article, I believe you have a certain understanding of "how to use the ORDER BY clause in SQL". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.