SQL语法练习

SELECT … CASE … WHEN … THEN语句

SELECT
	STUDENT_NAME,
	(CASE WHEN score < 60 THEN '不及格'
		WHEN score >= 60 AND score < 80 THEN '及格'
		WHEN SCORE >=80 THEN '优秀'
		ELSE '异常' END
	)AS alias
FROM
	TABLE

SQL语句执行顺序

一般情况下的执行顺序：

(1)from
 
(2)on
 
(3)join
 
(4)where
 
(5)group by
 
(6)having
 
(7)select
 
(8)distinct
 
(9)union
 
(10)order by