SELECT *
FROM NOTICE WHERE 1 = 1 AND (Z_STATUS = 1 AND RELEASE_DEPT_ID = '-1' AND IS_ISSUE = 1 OR INSTR(RELEASE_DEPT_ID, '109') > 0) AND ID = '9F754701039E4903811E57589B19B18A'ORDER BY ISSUE_DATE DESC
本文共 251 字,大约阅读时间需要 1 分钟。
SELECT *
FROM NOTICE WHERE 1 = 1 AND (Z_STATUS = 1 AND RELEASE_DEPT_ID = '-1' AND IS_ISSUE = 1 OR INSTR(RELEASE_DEPT_ID, '109') > 0) AND ID = '9F754701039E4903811E57589B19B18A'ORDER BY ISSUE_DATE DESC
转载于:https://www.cnblogs.com/lxcmyf/p/6756765.html