SQL TSQL - 如何对 2 列使用 case 语句？

TSQL - How to use a case statement for 2 columns?

提问by Malcolm

I want to do a case on the result of 2 columns. How do I do this?

我想对 2 列的结果做一个案例。我该怎么做呢？

e.g.:

例如：

SELECT CASE amount=100 AND DATE IS NOT NULL WHEN 0 THEN 'Something' ELSE ''

Something like that?

类似的东西？

回答by Marc Gravell

select case
    when amount = 100 and date is not null then 'something'
    else 'something else'
    end

This is a "searched case expression" (see MSDN):

这是一个“搜索案例表达式”（参见 MSDN）：

    CASE
      WHEN Boolean_expression THEN result_expression [ ...n ] 
      [ ELSE else_result_expression ]  END

回答by Mitch Wheat

select someColumnName,
       case 
         when amount = 100  AND someothercondition then 'XXX'
         when amount = 1000  AND anothercondition then 'YYY'
         else 'WWW' 
       end as "MyColumnName"
from myTable

回答by Mufaka

select 
case 
    when 
        amount = 100 
        and date is not null    
    then 
        '0'
    else 
        'something else'
end  

回答by shahkalpesh

Look for SELECT WHEN

寻找 SELECT WHEN

http://www.4guysfromrolla.com/webtech/102704-1.shtml

http://www.4guysfromrolla.com/webtech/102704-1.shtml

回答by Suhail

select case when amount = 100 and date is not null then 'something' else 'something when amount=0 then 'something else' end as MyColumnName

选择 case when amount = 100 and date is not null then 'something' else 'something when amount=0 then 'something else' 以 MyColumnName 结尾