展开全部
降序
SELECT * FROM kc ORDER BY cpbh DESC
升序
SELECT * FROM kc ORDER BY cpbh asc
实例:62616964757a686964616fe4b893e5b19e31333366306466
/*查询学生表中姓名、学号,并以学号降序排序*/
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 默认为升序*/
扩展资料
ORDER BY 语句:
ORDER BY 语句用于根据指定的列对结果集进行排序。
ORDER BY 语句默认按照升序对记录进行排序。
实例:
1,AddTime 升序,ID 升序
select * from DS_Finance ORDER BY AddTime,ID;
2,AddTime 升序,ID降序
select * from DS_Finance ORDER BY AddTime,ID DESC;
3,AddTime 降序,ID升序
select * from DS_Finance ORDER BY AddTime DESC,ID ;
4,AddTime 降序,ID降序
select * from DS_Finance ORDER BY AddTime DESC,ID DESC;