Re: newbie - duplicate rows

Try this

 select a.*, count(*)
from table_name a
group by a.field1, a.field2, ..., a.fieldN having count(*) > 1;

If this gives you an error, substitute a.field1, a.field2, ..., a.fieldN for a.* on the first line.

Marc Lodico
mlodico_at_bigfoot.com

Hung Binh wrote:

> How do I query all duplicated rows in a table?
>
> Thanks
Received on Thu Jan 15 1998 - 00:00:00 CET