排序查询

查询语句

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;