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

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL for getting duplicate records?

Re: SQL for getting duplicate records?

From: Wolf 'n Pinguin <duif.op.spijkers_at_wxs.nl>
Date: 14 Aug 1999 23:30:49 GMT
Message-ID: <01bee6a8$1e547be0$dee179c3@nentjesi> 







Paul Q <paulq_at_home.com> schreef in artikel
<T9Is3.6579$C6.60143_at_news2.rdc1.on.home.com>...


> select * from table a


> /*at least one condition */


> where field=a.field


> /* maybe others */


> /* and field2=a.field2


>   ...


> */


> 


> and rowid !=a.rowid


> ..





No, this will return every record in the table that has neither field=NULL 
and field2=NULL   (since NULL isn't equal to NULLL in SQL).



Sorry, Ide
Received on Sat Aug 14 1999 - 18:30:49 CDT












Original text of this message













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