Re: Duplicate items in a table
From: RK <rajxesh_at_hotmail.com>
Date: 26 Jun 2002 06:57:05 -0700
Message-ID: <86c750f4.0206260557.4b23cd7f_at_posting.google.com>
Date: 26 Jun 2002 06:57:05 -0700
Message-ID: <86c750f4.0206260557.4b23cd7f_at_posting.google.com>
forlist2001_at_yahoo.com (kumu) wrote in message news:<a44abd39.0206250720.7c0a637f_at_posting.google.com>...
> Hello,
>
> Please let me know the script that will print out only duplicate
> records within the table.
>
> I have a table with column1... column n and have to find duplicate
> records whithin column 5 and column 6.
>
> thanks a lot
> Kumu
You can try
SELECT col1, COUNT(col1)
FROM yourtable
GROUP BY col5, col6
HAVING COUNT(col1) > 1
- rajXesh