SQL tutorial-Sort data

Sort data

To sort the result from using the SELECT statement, you need to use ORDER BY keyword before the field name that you want to sort by. You can sort the data in ascending or descending.

-Sort data by ascending order To sort data by ascending order, the keyword ASC is used immediately after the keyword ORDER BY. SELECT field-name1,[field-name2],... FROM table-name ORDER By field-name ASC

TblBook table:

BookID

PublisherID

Title

ISBN

B001

P001

Microsoft Access 2007

123-456-435678-9

B002

P002

C programming language for beginners

234-456-9876523-8

B003

P003

C++ programming from the ground up

345-451-890087-2

Example: SELECT * FROM TblBook; ORDER BY Title ASC;

Result:

BookID

PublisherID

Title

ISBN

B002

P002

C programming language for beginners

234-456-9876523-8

B003

P003

C++ programming from the ground up

345-451-890087-2

B001

P001

Microsoft Access 2007

123-456-435678-9

-Sort data by descending order To sort data by ascending order, the keyword DESC is used immediately after the keyword ORDER BY. SELECT field-name1,[field-name2],... FROM table-name ORDER By field-name DESC

Example: SELECT * FROM TblBook; ORDER BY BookID DESC;

Result:

BookID

PublisherID

Title

ISBN

B003

P003

C++ programming from the ground up

345-451-890087-2

B002

P002

C programming language for beginners

234-456-9876523-8

B001

P001

Microsoft Access 2007

123-456-435678-9

Note:-You can sort data by multiple fields. To sort data by multiple fields you need to use the following prototype:

This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages: C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.