In my below query when i pass COUNTRY value as SG i'm getting NAME ='CCC' which is correct.
same time when i pass COUNTRY value as UK i wanted result as NAME=BBB and i dont want the next row ( it shows 'ccc' also)
WITH T AS (SELECT 'AAA' NAME , 'US' COUNTRY FROM DUAL UNION ALL
SELECT 'BBB' NAME , 'UK' COUNTRY FROM DUAL UNION ALL
SELECT 'CCC' NAME , 'OTHERS' COUNTRY FROM DUAL
)
SELECT T.* FROM T
WHERE (COUNTRY = 'UK' OR COUNTRY='OTHERS')
--WHERE (COUNTRY = 'SG' OR COUNTRY='OTHERS')
--WHERE (CASE WHEN COUNTRY = 'SG' THEN COUNTRY ELSE 'OTHERS' END) ='SG'