排序操作

排序

例子：

select * from  instructororder by salary desc, name asc

desc降序，asc升序

between

select namefrom instructorwhere salary between 90000 and 100000