By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
WITH yourTable AS (
SELECT 'Hierarchy' AS Column1, 'Relate' AS Column2 UNION ALL
SELECT 'Hierarchy', 'Norelate' UNION ALL
SELECT 'Single', 'Relate' UNION ALL
SELECT 'Single', 'Norelate'
)
SELECT *
FROM yourTable
WHERE Column1 IN ('Hierarchy', 'Single') AND Column2 IN ('Relate', 'NoRelate') AND
NOT (Column1 = 'Single' AND Column2 = 'NoRelate');
| Column1 | Column2 |
|---|---|
| Hierarchy | Relate |
| Hierarchy | Norelate |
| Single | Relate |