By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE table_name ( acct_nbr, counter_1, Counter_2, counter_3 ) AS
SELECT 1234, 1, 1, 1 FROM DUAL UNION ALL
SELECT 2345, 0, 2, 1 FROM DUAL UNION ALL
SELECT 5678, 1, 0, 1 FROM DUAL UNION ALL
SELECT 9876, 0, 0, 1 FROM DUAL UNION ALL
SELECT 4567, 1, 0, 0 FROM DUAL UNION ALL
SELECT 2804, 0, 1, 1 FROM DUAL UNION ALL
SELECT 4321, 2, 1, 1 FROM DUAL UNION ALL
SELECT 7654, 0, 0, 0 FROM DUAL;
8 rows affected
SELECT *
FROM table_name
WHERE ( counter_1 = 1 OR counter_2 = 1 OR counter_3 = 1 )
AND counter_1 <= 1
AND counter_2 <= 1
AND counter_3 <= 1
| ACCT_NBR | COUNTER_1 | COUNTER_2 | COUNTER_3 |
|---|---|---|---|
| 1234 | 1 | 1 | 1 |
| 5678 | 1 | 0 | 1 |
| 9876 | 0 | 0 | 1 |
| 4567 | 1 | 0 | 0 |
| 2804 | 0 | 1 | 1 |