1.第一种用or
select * from test where (province <>'广东' or yr <>'2023')
2.第二种用not
select * from test where not (province ='广东' and yr ='2023')
SQL中满足两个条件均不满足或均不等于某个值时的写法
于 2023-10-13 10:40:38 首次发布
1.第一种用or
select * from test where (province <>'广东' or yr <>'2023')
2.第二种用not
select * from test where not (province ='广东' and yr ='2023')