Intopia的博客sql 升序降序排列降序:SELECT * FROM kc ORDER BY cpbh DESC升序:SELECT * FROM kc ORDER BY cpbh ASC语法:sql可以根据字段进行排序,其中,DESC表示降序,ASC表示升序order by 字段名 DESC;按照字段名降序排序...
weixin_39898550的博客sql 升序降序排列降序 SELECT * FROM kc ORDER BY cpbh DESC 升序 SELECT * FROM kc ORDER BY cpbh asc 实例: /*查询学生表中姓名、学号,并以学号降序排序*/ select name,StuID from Students_information order ...