case语句的问题，我得到一个语法错误

Question

我正在尝试在表上创建一个新列。我找不到问题，有什么帮助吗?

感谢

SELECT
R.client AS Client
CASE Client 
WHEN IS NOT NULL THEN 1 
ELSE 0 
END AS 'Real Clients'
FROM Request R

Answer 1

正确的语法是:

SELECT
R.client AS Client
,CASE WHEN Client IS NOT NULL THEN 1 ELSE 0 END AS 'Real Clients'
FROM Request R