Re: identical columns

You can try

  select *, rowid from table_t1
  where duplicate_column_name in
   (select distinct(duplicate_column_name) from table_t1

       group by duplicate_column_name
       having count(*) > 2)

This will give you all the information about the duplicate column values

"José Nicolau" 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
Received on Wed Dec 23 1998 - 16:44:56 CST