sql - 选择 'EXIST' 或 'NotExist' 作为列

Question

我有以下 SQL，

SELECT SKU FROM Products WHERE SKU IN
(
   'SKU1',
   'SKU2',
   'SKU3',
   'SKU4',
   ......
   ......
   ......

   'SKUN',
)

我需要选择的是

 SKU    Exist
 ----------
 SKU1    Exist
 SKU2    NotExist
 SKU3    NotExist
 ................
 ................
 ................
 SKUN    NotExist

Answer 1

WITH SKUs AS (
    SELECT SKU
    FROM (VALUES ('SKU1'),('SKU2'),...) AS T(SKU)
)
SELECT SKUs.SKU
      ,CASE WHEN Products.SKU IS NULL THEN 'NotExists' ELSE 'Exists' END
FROM SKUs
     LEFT JOIN Products
         ON Products.SKU = SKUs.SKU