Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: SQL join to identify missing records?

Re: SQL join to identify missing records?

From: f morel <florian.morel_at_actiware.fr>
Date: Fri, 25 Aug 2000 10:44:57 +0200
Message-ID: <8o5bl7$h7j$1@wanadoo.fr> 






I think that the query using minus is the fastest.



> select distinct id from table1

> minus

> select distinct id from table2

> /




"distinct" is not necessary. A query using "minus" will always return
distinct values.



select id from table1


minus


select id from table2




Florian Morel
Received on Fri Aug 25 2000 - 03:44:57 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US