SELECT STU_NAME AS '學(xué)生名',STU_SCORE AS '成績'
FROM STUDENT
ORDER BY STU_SCORE DESC/*按成績降序進行排序*/
--------------------------------------
SELECT STU_NAME AS '學(xué)生名',STU_SCORE AS '成績'
FROM STUDENT
ORDER BY STU_SCORE ASC/*按成績降序進行排序*/