SQL Server Where Condition

Question

Consider having the ff. table (#temp_table)

How do I make a select query where first, I will exclude all rows where column2 = mark then exclude all rows where column2 = jim and column1 = value2

The expected result set should be

The query I have tried so far is

select * from #temp_table where column2 != 'mark' and (column2 !='jim' and column1 != 'value2')

The result of my query

id	column1	column2
3	value3	taylor
4	value4	tess

Don't do != --> <> ........ column2 <> 'mark' AND NOT (column2 ='jim' and column1 = 'value2') — T.S.
– T.S., Commented Mar 29, 2023 at 4:43

Leandro Bardelli · Accepted Answer · 2023-03-29 04:46:30Z

You can "negate" a group of conditions using the operator NOT before the group

select * from #temp_table where column2 != 'mark' and NOT (column2 ='jim' and column1 = 'value2')

1 Answer 1