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降序排
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降序排