r4r Right place for Right person^®

MySQL

R4R^® MySQL

MySQL Interview Materials

MySQL subjective question

MySQL Interview question

MySQL Objective question

MySQL FAQS

RDMS FAQS

Oracle Interview Questions

(追記) (追記ここまで)

adplus-dvertising

(追記) (追記ここまで)

Order By in MySQL

Previous Home Next

In this clause we are sorting the table according to the specified order given. Default sorting order is ascending order in sorting of numeric values , where as in letters it follow alphabetical order.

Syntax

SELECT *
FROM tablename
ORDER BY value1, value2;

here some examples is given below

SELECT *				//show all values
FROM studadr				//studadr is a tablename
ORDER BY aid ;				//sorting numeric value default

(追記) (追記ここまで)

Example

SELECT *				//show all values
FROM studadr				//studadr is a tablename
ORDER BY aid desc ;			//sorting numeric value in descending order

Note Use DESC also used to reverse alphabetical to get the output in reverse order

Example

SELECT *					//show all values
FROM studadr					//studadr is a tablename
ORDER BY locatn, state ;			//ordering order is given

Note Use locatn and state both to get the output in which order preferences is given to get the output

Example

SELECT *					//show all values
FROM studadr					//studadr is a tablename
WHERE aid > 108					//Condition can be use
ORDER BY aid;					//ordering order is given

Example

SELECT *					//show all values
FROM studadr					//studadr is a tablename
WHERE aid > 108					//Condition can be use
ORDER BY locatn,state ;				//ordering order is given

Previous Home Next

(追記) (追記ここまで)

R4R Topics