5排序查询

Mysql排序查询

1.升序排序

select * from worker order by age;

2.降序排序

select * from worker order by entrydate desc;

3.组合排序

先按照第一个规则排序，相同数量，再按照第二个规则排序

select * from worker order by age,entrydate desc;