order by排序

order by 排序默认是id 升序排的!

select * from employee order by age asc; (年龄从小到大排)

select * from employee order by age desc; (年龄从大到小排)

select * from employee order by age asc,id desc; 先按照age 升序排,如果age相同则按照ID降序排

 

posted on 2019-10-13 15:46  kingforn  阅读(150)  评论(0)    收藏  举报