Question

我的议席上有2个领域,我需要说明。

Col1          Col2     Col3
abc.txt       Y        0
def.txt       N        0
bbck.txt      Y        1

The Col3 values are based on the Col1 and Col2 values in the following manner.
Y = 1 and N = 0. So all the values in Col2 that are Y shall become 1 in col3, and Nin Col2 will become 0 in Col3, UNLESS the col1 value ends with %c.txt. As you can see since the abc.txt ends with %c.txt the value in col3 becomes 0.

我知道,可以通过一份<代码>CASE的声明来做到这一点。是否有任何人知道如何?

我的法典

SELECT 
  CASE Col2
    WHEN  Y  THEN  1 
    WHEN  N  THEN  0 
  ELSE
(CASE WHEN [Col1] LIKE  %c.txt  THEN  0 
 END)
  END
  AS Col3,
 *
FROM Tabl1

希望这一想法

Answer 1

或许:

SELECT 
    CASE 
      WHEN Col2 =  N 
        OR Col1 LIKE  %c.txt 
          THEN  0 
      WHEN Col2 =  Y 
          THEN  1 
    END AS Col3
  , * 
FROM Tabl1

Answer 2

SELECT 
  CASE WHEN Col2 LIKE  %c.txt  THEN  0 
       ELSE
       CASE 
            WHEN Col2  =  N   THEN  0 
            WHEN Col2  =  Y  THEN  1 
       END
  END AS COL3
FROM Tabl1

Answer 3

我并不认为你的幽灵是清楚的,例如,在“联合国升温潜能值”一词之前的 com是否假定以下条款适用于之前的条款?

似乎有四种可能的组合:

1) Col1 LIKE  %c.txt 
   AND Col2 =  Y 

2) Col1 LIKE  %c.txt 
   AND Col2 =  N 

3) Col1 NOT LIKE  %c.txt 
   AND Col2 =  Y 

4) Col1 NOT LIKE  %c.txt 
   AND Col2 =  N

你的话

一、需要案件陈述

情况如何? 同样,总是能够以多种方式实现(这就是为什么如此难以建立一个更优化的平台:) 我认为,为了执行《<><><>>,需要一个幽灵,而不是对<>strong>施加不合理的限制。

以下用途:<条码>UNION,而不是例例,如果您从一开始就认为了这一点,那么你的幽灵会更好;]

WITH Tabl1
     AS 
     (
      SELECT * 
        FROM (
              VALUES ( abc.txt ,  Y ),
                     ( def.txt ,  N ),
                     ( bbck.txt ,  Y ),
                     ( disc.txt ,  N )
             ) AS T (Col1, Col2)
     )
SELECT  0  AS Col3, *
  FROM Tabl1
 WHERE Col1 LIKE  %c.txt 
       AND Col2 =  Y 
UNION
SELECT  0  AS Col3, *
  FROM Tabl1
 WHERE Col1 LIKE  %c.txt 
       AND Col2 =  N 
UNION
SELECT  1  AS Col3, *
  FROM Tabl1
 WHERE Col1 NOT LIKE  %c.txt 
       AND Col2 =  Y 
UNION
SELECT  0  AS Col3, *
  FROM Tabl1
 WHERE Col1 NOT LIKE  %c.txt 
       AND Col2 =  N ;

P.S. I. P. P.S. P. P.S. P.,这是为了与接受的答复相匹配,但我不相信这是正确的!

Answer 4

This might be what your looking for:

 SELECT * FROM Tabl1
 cross apply
    (
      select Col3 =
      CASE  
            WHEN Tabl1.Col2 =  Y  then  1 
            WHEN Tabl1.Col2 =  Y  then  1 
            WHEN RIGHT(Tabl1.Col1, 6) =  c.txt  then  0 
            END 
) as Col3

友情链接