-- 默认为升序,desc是降序 select name,StuID from Students order by StuID desc -- 升序 select name,StuID from Students order by StuID