您可以尝试：

SELECT Name, A, B, C, 
    CASE 
        WHEN 'Y' IN (A,B) OR 'Y' IN (A,C) OR 'Y' IN (B,C) THEN 'Y'
        ELSE 'N'
    END AS Res
FROM [table_name];

如果你有很多列，并且可以使用UNPIVOT，你可以这样做：

SELECT u.Name
FROM 
(
    SELECT Name, A, B, C
    FROM your_table_name
) DS
UNPIVOT 
(
    Res FOR Col IN (A, B, C)
) UNPVT
WHERE UNPVT.Res = 'Y'
GROUP BY UNPVT.Name
HAVING COUNT(DISTINCT u.Col) >= 2;

SELECT *, case when A = "Y" AND B = "Y" then "Y"
               when B = "Y" AND C = "Y" then "Y"
               when A = "Y" AND C = "Y" then "Y"
               else "N"
               end as Res
FROM your_table