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