AND (case when( E.DutyName not like '%总经理%' AND E.DutyName not like '%总监%' ) then 1 else 0 end) =1
与
AND E.DutyName not like '%总经理%' AND E.DutyName not like '%总监%'
看似一样实则天差地别的SQL条件(自记录)
最新推荐文章于 2024-07-25 15:08:38 发布
AND (case when( E.DutyName not like '%总经理%' AND E.DutyName not like '%总监%' ) then 1 else 0 end) =1
与
AND E.DutyName not like '%总经理%' AND E.DutyName not like '%总监%'