è¿ä¸ªé®é¢æ¯éååçé®é¢
å¾å¯æ ä½ è¿ä¸ªæ¯mysqlï¼åªè½ç¨not in
select?id?from?客æ·è¡¨
where?id?not?in?
(
select?id?from?æ°æ®è¡¨1?WHERE?ä¸ä¼ æ°æ®æ¶é´>now()-7
union
select?id?from?æ°æ®è¡¨2?WHERE?ä¸ä¼ æ°æ®æ¶é´>now()-7
union
select?id?from?æ°æ®è¡¨3?WHERE?ä¸ä¼ æ°æ®æ¶é´>now()-7
union
select?id?from?æ°æ®è¡¨2?WHERE?ä¸ä¼ æ°æ®æ¶é´>now()-7
)
å¦æä½ ä½¿ç¨çæ¯oracleï¼è¿ææçæ´é«çæ¹æ³ï¼ç¨å
³é®åminus
select?id?from?客æ·è¡¨
minus
select?id?from?æ°æ®è¡¨1?WHERE?ä¸ä¼ æ°æ®æ¶é´>sysdate-7
minus
select?id?from?æ°æ®è¡¨2?WHERE?ä¸ä¼ æ°æ®æ¶é´>sysdate-7
minus
select?id?from?æ°æ®è¡¨3?WHERE?ä¸ä¼ æ°æ®æ¶é´>sysdate-7
minus
select?id?from?æ°æ®è¡¨2?WHERE?ä¸ä¼ æ°æ®æ¶é´>sysdate-7
æè
sqlserver使ç¨å
³é®åexcept
select?id?from?客æ·è¡¨
except
select?id?from?æ°æ®è¡¨1?WHERE?ä¸ä¼ æ°æ®æ¶é´>getdate()-7
except
select?id?from?æ°æ®è¡¨2?WHERE?ä¸ä¼ æ°æ®æ¶é´>getdate()-7
except
select?id?from?æ°æ®è¡¨3?WHERE?ä¸ä¼ æ°æ®æ¶é´>getdate()-7
except
select?id?from?æ°æ®è¡¨2?WHERE?ä¸ä¼ æ°æ®æ¶é´>getdate()-7
以ä¸
温馨提示:答案为网友推荐,仅供参考