order by.sql

初学者

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/*按成绩降序进行排序*/