学说不在哪里

Question

I have a table in DB like that

i want to select all except the record contain (x=1, y=1) i mean the id=8

id  |  x  |  y
---------------
1   |  2  |  1
2   |  0  |  1
3   |  5  |  6
4   |  6  |  4
5   |  7  |  4
6   |  7  |  4
7   |  5  |  7
8   |  1  |  1

Answer 1

Try this: see the DEMO

select * from TableName where 1 NOT IN(x,y)