1 order by

(1) 从小到大 (asc, 默认)

select * from people where (age between 18 and 34) order by age;
注: 可以不写(), 只是为了可读性高才写的

(2) 从大到小 (desc)

select * from people where (age between 18 and 34) order by height desc;