select id ,code,style_code,del_yn
from table
where del_yn = 'n' and ((code = 'shanghai' and style_code = 'online_news') or (style_code = 'news' and code = 'shanghai_main'))
select id ,code,style_code,del_yn from table where (code = 'shanghai' and style_code = 'online_news') or (style_code = 'news' and code = 'shanghai_main' and del_yn = 'n' )
我不明白是什么意思,按我的理解写一个:
select id ,code,style_code,del_yn from table where (code = 'shanghai' and style_code = 'online_news') or (style_code = 'news' and code = 'shanghai_main') and del_yn = 'n'
不知道理解的对不对?