如何为IF THEN问题提供案例

Question

我正在尝试选择符合以下条件的行

    IF kid=IND and kid=Family 
       then select Kid=IND 
    If kid only has Family 
       then select family. 
    if kid only has IND 
       then select IND.      

我该如何使用CASE进行此操作？

前任。

kid_id   date       type
001      1/1/2013   IND
001      1/1/2013   Family
002      1/2/2013   Family
003      1/3/2013   IND

结果

001   1/1/2013   IND
002   1/2/2013   Family
003   1/3/2013   IND 

Answer 1

select 
case 
When (kid=ind and kid=family) Then ind
When kid=family then family
When kid=ind then ind
else
  null
end
From SomeTable

给定kid，ind和family是表中的列。

你是说像这样的东西吗

select kid_id,date, 
case 
When (kid=ind and kid=family) Then 'Both'
When kid=family then family
When kid=ind then ind
else
  'None'
end as TypeGroup
From SomeTable