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: identical columns

Re: identical columns

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Wed, 9 Sep 1998 21:50:39 +0200
Message-ID: <6t6m43$lg2$1@newton.a2000.nl> 





>I have the following problem: I have a table of which I know that it


>contains duplicate rows. I want to find all rows that are duplicate.






    select name, count(*)


    from emp


    group by name


    having count(*) > 1;



If you need to delete the duplicate rows, then search for quite recent posts
in these newsgroups.



Arjan.



Received on Wed Sep 09 1998 - 14:50:39 CDT












Original text of this message













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