#为从小到大,字母优先 select * from table_name order by age; #表示从大到小,desc select * from table_name order by age desc;