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;
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;