Re: Duplicate items in a table
From: kumu <forlist2001_at_yahoo.com>
Date: 1 Jul 2002 17:00:17 -0700
Message-ID: <a44abd39.0207011600.1815a7b2_at_posting.google.com>
Date: 1 Jul 2002 17:00:17 -0700
Message-ID: <a44abd39.0207011600.1815a7b2_at_posting.google.com>
Thanks I tried the script and it works.... :0)
rajxesh_at_hotmail.com (RK) wrote in message news:<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
Received on Tue Jul 02 2002 - 02:00:17 CEST