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,166 questions

40,722 answers

573 users

How to order by two columns in SQL and MySQL

Freaking Awesome WordPress Hosting
158 views
asked Sep 18, 2016 by avibootz
edited Sep 19, 2016 by avibootz

1 Answer

0 votes
ORDER BY u_address ASC, u_score DESC

-- ASC is default, so you can omit the keyword ASC

ORDER BY u_address, u_score DESC

 





answered Sep 18, 2016 by avibootz

Related questions

1 answer 115 views
1 answer 128 views
1 answer 186 views
1 answer 129 views
1 answer 195 views
...