Conditions in Where clause

SELECT *
FROM MyTable
WHERE (CASE WHEN columnA = 'A' AND Status = 'B' AND columnC = 'A1' THEN 0 ELSE 1 END) = 1

Select allOpen in new window

You can just specify that condition and everything else is "true", and then limit the results to just records that evaluate to "true"

SELECT FROM TabNAme
WHERE columnA  = 'A'
              and Status = 'B'
              and ColumnC  <> 'A1'

E.g.

SELECT T.* 
FROM schemaName.tableName T 
WHERE NOT (T.columnA = 'A' AND T.Status = 'B') AND NOT columnC = 'A1';

Select allOpen in new window

The above condition should only apply for scenario when columnA  = 'A'  and Status = 'B' not for other values

And in that case where does the "...then eliminate records in columnC where ColumnC  = "A1" stands? Is that needed or not?
If all needed is indeed "...only apply for scenario when columnA  = 'A'  and Status = 'B' " then the SELECT would be like:

SELECT FROM TabNAme
WHERE columnA  = 'A'
              and Status = 'B'

select * from table
except
select * from table
where columnA = 'A'
and Status = 'B'
and columnC = 'A1'

I am using this CASE statement but it is failing
Where ColumnC <> (CASE WHEN  ColumnA ="A" AND Status = "B" THEN "A1" ELSE Nothing END)

select * from tablename
WHERE ColumnC <> (CASE WHEN  ColumnA = 'A' AND [Status] = 'B' THEN 'A1' ELSE NULL END)