Question

SQL SERVER语句： 我想在SELECT中加入判断，

原来的语句是SELECT amount ， number FROM TABLENAME；现在 增加一列， 现在要把amount这一列替换掉，当amount大于 1000， 显示为big，当amount小于1000，显示为Small；怎么写？

Answer 1

SELECT CASE WHEN [amount] > 1000 THEN 'big' ELSE 'Small' END AS [amount], [number] FROM [TABLENAME]

Answer 2

select amount,number,
case when (amount>1000) then 'big'
when (amount< 1000) then 'small'
else '0' end
from TABLENAME

Answer 3

CASE WHEN THEN ELSE THEN END