Re: Removing duplicate records

[John Yeung <gallium.arsenide@xxxxxxxxx>]

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)