是的，这是可能的。假设您的表名为payment\u table，并且该列被称为mode\u of \u payment：

SELECT mode_of_payment, 
CASE
    WHEN mode_of_payment = 'cash' THEN 'YES'
    ELSE 'NO'
END AS is_cash
FROM
payment_table

有两种选择。 case .. when 陈述 decode --

Case when upper(col) = 'CASH' then
     'YES' else 'NO' end as is_cash
-- or
Decode(upper(col), 'CASH', 'YES','NO') as is_cash

其他栏目自己做。

像这样的事情可能会有帮助

SELECT CASE 
        WHEN Col = 'Cheque'
            THEN 'Yes'
        ELSE 'No'
        END AS Cheque
    , CASE 
        WHEN Col = 'Cash'
            THEN 'Yes'
        ELSE 'No'
        END AS Cash
    , CASE 
        WHEN Col = 'dd'
            THEN 'Yes'
        ELSE 'No'
        END AS dd
    , CASE 
        WHEN Col = 'pdc '
            THEN 'Yes'
        ELSE 'No'
        END AS pdc
FROM MyTable

您可以使用它来实现最佳解决方案：

select mode_payment,
(case when mode_payment = 'CASH' then 'YES' else 'NO' end) cash,
(case when mode_payment = 'RTGS' then 'YES' else 'NO' end) RTGS,
(case when mode_payment = 'CHEQUE' then 'YES' else 'NO' end) CHEQUE,
(case when mode_payment = 'NEFT' then 'YES' else 'NO' end) NEFT,
(case when mode_payment = 'DD' then 'YES' else 'NO' end) DD
from tablename