1.  Home
  2. MIDRANGE-L
  3. January 2012

Re: Removing duplicate records

On Fri, Jan 20, 2012 at 10:54 AM, Gary Thompson <gthompson@xxxxxxxxxxx> wrote:
John
Create an identical work file
Then use SELECT DISTINCT to select from table with dups,
       inserting into your work file:

CREATE TABLE  mylib/wkfile  AS
     ( SELECT  DISTINCT fld1, fld2, ... fldn
         FROM  alib/dupfile )
     WITH DATA

Of course! DISTINCT is perfect for this. I feel quite silly for not
remembering this keyword. (I totally do not use SQL enough.)

The other solutions probably have their selling points, but I find
this one the most elegant and easiest to understand.

John Y. (not to be confused with John McKee)

This thread ...
Follow-Ups:
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.