/*查询学生表中姓名、学号,并以学号降序排序*/select name,StuID from Students_information order by StuID desc /**order by 以什么排序,默认为升序,desc是降序*//*查询学生表中前5名学生的姓名,学号,并以学号升序排列*/select top 5 name,StuID from Students_information order by StuID /*order by 默认为升序*/
如果觉得《SQL 升序 降序排列》对你有帮助,请点赞、收藏,并留下你的观点哦!