排序
例子:
select *
from instructor
order by salary desc, name asc
desc降序,asc升序
between
select name
from instructor
where salary between 90000 and 100000
例子:
select *
from instructor
order by salary desc, name asc
desc降序,asc升序
select name
from instructor
where salary between 90000 and 100000