“minus”直接翻譯為中文是“減”的意思,在Oracle中也是用來做減法操作的,只不過它不是傳統(tǒng)意義上對數(shù)字的減法,而是對查詢結(jié)果集的減法。A minus B就意味著將結(jié)果集A去除結(jié)果集B中所包含的所有記錄后的結(jié)果,即在A中存在,而在B中不存在的記錄。其算法跟Java中的Collection的removeAll()類似,即A minus B將
INTERSECT SELECT member_id, name FROM b can simply be rewritten to 復(fù)制代碼代碼如下: SELECT a.member_id, a.name FROM a INNER JOIN b USING (member_id, name) Performing a MINUS To transform the statement 復(fù)制代碼代碼如下: SELECT member_id, name FROM a MINUS SELECT member_id, name FROM ...