Re: query to find duplicate rows

[Steve Musumeche]

Select COUNT(*) as num_entries, url from table WHERE num_entries>1 GROUP 
BY url

Untested, but the concept should work for you.

Steve Musumeche
CIO, Internet Retail Connection
steve@stripped



Peter Van Dijck wrote:
> Hi all, a though query problem for me...
>
> I have a table with 2 rows that matter: url and id
>
> If url and id are the same in 2 rows, then that's no good (bad data).
>
> I need to find all the rows that are duplicates. I can't think of how
> to approach the sql for this.. any pointers?
>
> Thanks!
> Peter
>