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:32:11 GMT
Message-ID: <01bee6a8$4fcbc0c0$dee179c3@nentjesi> 





> 


> select count(*), c1, c2, c3, c4, ....


> from T


> group by c1, c2, c3, c4, ....


> having count(*) > 1


> /


> 


> 


> that'll show you how many times each distinct set of values ocurrs if


that set


> of values ocurrs more then once.





True, but if you want the entire record, than tyiping in all the fields in
a lot of work.



Ide
Received on Sat Aug 14 1999 - 18:32:11 CDT












Original text of this message













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