查询语句
order by
ASC :升序(默认)
DESC:降序
1.升序查询:按age升序
select * from person order by age ASC;
select * from person order by age ;
2.降序查询:按age降序
select * from person order by age DESC;
3.按age先升序查询,如果age相同,相同的按id将序查询:
select * from person order by age ASC,id DESC;