Retrieving Unique records and inserting into new file via SQL

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.