ORDER BY

想让数据从小到大排 → 升序 ASC
想让数据从大到小排 → 降序 DESC

create table studentss
(

name nvarchar(10),
age int

);

insert into studentss
values
('张三',18),
('李四',20),
('王五',16),
('赵六',19);

select *
from studentss
ORDER BY age ASC;

select * from studentss
ORDER BY age DESC;

--查询年龄>18 并按照年龄从大到校排列
select *
from student
where age >18
ORDER BY age DESC;