SQL的ORDER BY 关键字,INSERT INTO语句,UPDATE语句,DELETE语句 ORSER BY 关键字 ORDER BY 关键字用于对结果集按照一个列或者多个列进行排序。默认为升序,如果想要降序排列,需要DESC关键字 ORDER BY的语法 SELECT column_name,column_name FROM table_name ORDER BY column_name,column_name ASC|DESC; 注:ASC为升序,DESC为降序 例子依然是老师给的虚拟的“学生表” SNO SNAME SEX DEPT
