1:对指定列进行升序排列
Select * from user order by user_name

2:按照user_id逆序排列
Select * from user order by user_id DESC

2:按照升序排列user_id逆序排列user_age
SELECT * FROM user order by user_id ASC,user_age DESC

3:按照升序排列user_id逆序排列user_age
SELECT * FROM user order by user_age DESC,user_id ASC

注意:前面的条件优先级更高!!
希望能对大家有所帮助。


