Order By - in SQL
Posted in Programming, Query on Dec 13th, 2008
ms_user table
user_id
username
email
area_id
1
sherlock
c_sherlock@email.com
1
2
poirot
poirot@email.com
2
3
watson
b_watson@email.com
1
4
hasting
hasting@email.com
2
5
mycroft
a_mycroft@email.com
1
SELECT * FROM `ms_user`
ORDER BY `area_id` , `email` DESC , `username`;