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:

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.

Posted comments

TL Norman:

WHAT? No multi-dimensional array explanation/examples!

05-23-2013

Patrick:

Good explanations. Thank you :)

03-22-2013

Dara:

Global and local variables declaration example:
http://www.worldbestlearningcenter.com/tips/Global-variables-in-vba.htm

02-23-2013

ann:

thanks for sharing your knowledge it helps me a lot.

02-11-2013

Tamilan:

Pls post some examples for declaring and calling variables (local and global)

02-09-2013

M.somjate:

Thanks for example color code.

02-08-2013

G G Shah:

Heartly Thanks.God bless you.

01-18-2013

sek sam:

I like this website very much.
It has a lot of helpful helpful materials to learn excel programming.

01-01-2013

limocky:

useful ms access examples...
good web site to to learn access from scratch.

01-01-2013

bakery:

Thank for useful VBA example code...

12-27-2012

prasat:

Thank u for useful website..

11-03-2012

zal:

Thank for really helpful posts

10-28-2012

brasha:

Useful VBA examples for Excel. I really need them.

10-25-2012

.........................................................................................................................	Home \| Forum \| About \| Contact
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.
Copyright @ 2011-2013 worldbestlearningcenter. All Rights Reserved.