Re: Retrieving Unique records and inserting into new file via SQL

CREATE TABLE ROB/A5 (USERID CHAR (10 ) NOT NULL WITH DEFAULT,
DATAFLD CHAR (1 ) NOT NULL WITH DEFAULT)
Table A5 in ROB created but could not be journaled.
insert into a5 VALUES('SAM', 'A')
1 rows inserted in A5 in ROB.
insert into a5 VALUES('SAM', 'B')
1 rows inserted in A5 in ROB.
insert into a5 VALUES('SAM', 'C')
1 rows inserted in A5 in ROB.
CREATE TABLE ROB/A6 (USERID CHAR (10 ) NOT NULL WITH DEFAULT,
DATAFLD CHAR (1 ) NOT NULL WITH DEFAULT)
Table A6 in ROB created but could not be journaled.
SELECT * FROM ROB/A5
SELECT statement run complete.
USERID      DATAFLD
SAM            A
SAM            B
SAM            C
********  End of data  ********
INSERT INTO ROB/A6
SELECT USERID, MAX(DATAFLD) FROM ROB/A5
GROUP BY USERID,2
1 rows inserted in A6 in ROB.
SELECT * FROM ROB/A6
USERID      DATAFLD
SAM            C
********  End of data  ********

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin



                    Nel Dennis
                    <DNel3@OLDMUTUAL.co       To:     "Midrange-L (E-mail)" 
<midrange-l@midrange.com>
                    m>                        cc:
                    Sent by:                  Fax to:
                    midrange-l-admin@mi       Subject:     Retrieving Unique 
records and inserting into new file via
                    drange.com                 SQL


                    02/12/2002 04:05 AM
                    Please respond to
                    midrange-l






This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
Hi Group,

I have a file containing multiple records per userid. I now want to create
a
new file that will contain only one record for each userid. How can I do
this with SQL?

Thanks
Dennis Nel

Confidentiality Notice
This communication, its content and any file attachments transmitted with
it
are intended solely for the addressee(s) and may contain confidential
proprietary information. Access by any other party without the express
written permission of the sender is unauthorised. If you have received this
communication in error you may not copy, distribute or use the contents,
attachments or information in any way. Please destroy it and contact the
sender.


_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.