Welcome to collectivesolver - Programming & Software Q&A with code examples. A website with trusted programming answers. All programs are tested and work.

Contact: aviboots(AT)netvision.net.il

Prodentim Probiotics Specially Designed For The Health Of Your Teeth And Gums

Instant Grammar Checker - Correct all grammar errors and enhance your writing

Teach Your Child To Read

Powerful WordPress hosting for WordPress professionals

Disclosure: My content contains affiliate links.

31,167 questions

40,724 answers

573 users

How to use ORDER BY in SQL

Freaking Awesome WordPress Hosting
215 views
 

 

asked Sep 14, 2015 by avibootz
edited Sep 14, 2015 by avibootz

4 Answers

0 votes
-- Ascending order

SELECT * FROM Workers
ORDER BY Salary ASC

-- ASC (ascending) is the order by default, We don't need to write the keyword ASC 

SELECT * FROM Workers
ORDER BY Salary 

 





answered Sep 14, 2015 by avibootz
edited Sep 14, 2015 by avibootz
0 votes
-- Descending order

SELECT * FROM Workers
ORDER BY Salary DESC

 





answered Sep 14, 2015 by avibootz
0 votes
-- Ascending order

SELECT * FROM Workers
ORDER BY Age, Salary

 





answered Sep 14, 2015 by avibootz
0 votes
-- Ascending and Descending order

SELECT * FROM Workers
ORDER BY Age ASC, Salary DESC

 





answered Sep 14, 2015 by avibootz

Related questions

1 answer 115 views
1 answer 128 views
1 answer 186 views
1 answer 158 views
1 answer 130 views
...