order by.sql

来自「初学者」· SQL 代码 · 共 7 行

SELECT STU_NAME AS '学生名',STU_SCORE AS '成绩'
FROM STUDENT
ORDER BY STU_SCORE DESC/*按成绩降序进行排序*/
--------------------------------------
SELECT STU_NAME AS '学生名',STU_SCORE AS '成绩'
FROM STUDENT
ORDER BY STU_SCORE ASC/*按成绩降序进行排序*/