How can I get SQL query result except one specific row?

I have a personnel table. I want to get all records in this table except which has IT value as department and name is John.

These are my rows:

This is my query

select * 
from personnels per 
where (per.Name = 'John' and per.Department <> 'IT')

This is the result of that query:

Expected result

>Solution :

Try this;

SELECT * 
FROM personnels per
WHERE NOT (per.Name = 'John' AND per.Department = 'IT')

See Demo