Re: Duplicate Records SQL Question

Hi,

> >
>
> A more easy solution
>
> select <primary key columns> , count(*)
> from table
> group by <primary key columns>
> having count(*) > 1
>

I think he meant that the field memid is an unique field (primary key). That's
the reason for the little complicated solution.

> > Month, Memcode, Memid, PayAmt
> >
> > How do I list only the duplicate records for every month that have a
> > common memcode and payamt?

Regards,
Falko Rotter

• Software Developer -

Rotter & Kalweit Softwaredesign GbR
Friemarer Straße 38

99867 Gotha
GERMANY mail: news_at_falko-rotter.de Received on Tue Aug 21 2001 - 03:19:49 CDT