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
B001P001 Microsoft  Access 2007 123-456-435678-9
B002P002C programming language for beginners 234-456-9876523-8
B003P003C++ programming from the ground up 345-451-890087-2

Example:

SELECT *
FROM TblBook;
ORDER BY Title ASC;

Result:
BookID PublisherID Title ISBN
B002P002 C programming language for beginners 234-456-9876523-8
B003P003 C++ programming from the ground up 345-451-890087-2
B001P001 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
B003P003 C++ programming from the ground up 345-451-890087-2
B002P002 C programming language for beginners 234-456-9876523-8
B001P001 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:

SELECT field-name1,[field-name2],...
FROM table-name
ORDER By field-name1 [ASC|DESC], field-name2 [ASC|DESC], ....

-
Without specifying ASC or DESC, the order of data is ascending by default.


HTML Comment Box is loading comments...



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.