Re: Duplicate record utility?

["Jay peasley" <jpeasley@xxxxxxxxxxxxxx>]

Select field, count(*) from lib/file group by field having count(*) > 1

Jay


---------- Original Message ----------------------------------
From: D.BALE@handleman.com
Reply-To: MIDRANGE-L@midrange.com
Date: Mon, 29 Jan 2001 14:33:00 -0500

>SQL & the count(*) thingy...  it's been too long and I don't use SQL that
>often.  Hopefully this will spur a few answers from the group.
>
>You can do it using WRKQRY with two queries.  One that sorts by the duplicate
>data you're looking at and summarizes it with the COUNT option and outputs to
>an outfile.  The second reads the outfile and selects any counts greater than
>1.
>
>Dan Bale
>IT - AS/400
>Handleman Company
>248-362-4400  Ext. 4952
>
>-------------------------- Original Message --------------------------
>Does anybody know of (or have source for) a handy little utility to find
> duplicate records in a file?
>
>TIA,
>Nick
>
>Don't find fault, find a remedy.
>-Henry Ford
>+---
>| This is the Midrange System Mailing List!
>| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
>| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
>| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator: david@midrange.com
>+---
>
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---