and or

MoxiJun

于 2022-12-08 15:46:36 发布

阅读量88

点赞数

文章标签： sql

本文链接：https://blog.csdn.net/MoxiJun/article/details/128238242

版权

select distinct AMXI_ZT
from app_model_xqgl_itpo
where 1=1
  and AMXI_ZT ='XQZT01'
  or  AMXI_ZT ='XQZT02'  
	and AMXI_ZT ='XQZT03'
	and AMXI_ZT ='XQZT04'
	or  AMXI_ZT ='XQZT05'
	or  AMXI_ZT ='XQZT06'

效果等同

select distinct AMXI_ZT
from app_model_xqgl_itpo
where 1=1
  and AMXI_ZT ='XQZT01'
  or  (AMXI_ZT ='XQZT02'  and AMXI_ZT ='XQZT03' and AMXI_ZT ='XQZT04')
  or  AMXI_ZT ='XQZT05'
  or  AMXI_ZT ='XQZT06'

结论

2个or之间的 and 会自动分为一组