mysql 2008降序排列_sql 升序降序排列

展开全部

降序

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;