Re: identical columns

I've found the group by clause is useful for this..

select mycol, mycount from
  (select mycol, count(mycol) mycount from mytable    group by mycol) -- I suppose you can group by all columns here. where mycount > 1;

"José Nicolau" <jnicolau_at_hotmail.com> wrote:

> Try this
>
> select *
> from table t1
> where exists (select 0
> from table t2
> where t2.columns_with_duplicates = t1.columns_with_duplicates
> and t2.rowid != t1.rowid)
>
> You may use 'select distinct *...'
>
> Corinna Becker wrote:
>
> > Hello,
> > 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.
> > How can I do that?
> > Regards and thanks
> > Corinna Becker
>
>
>

--
joebrown
@leading.net Received on Tue Sep 15 1998 - 09:22:10 CDT