[NBLUG/talk] OT - SQL query question

[Mark Street]

This is slightly off topic.  I have an old dBase database with 12000 records.  
There are some records with the same address field.  I need to strip out the 
DISTINCT address records into a separate database.

SELECT DISTINCT ADDR1 FROM MYDB gets me the unique addresses but I need the  
other fields as well.

What would be the best way to do this?

-- 
Mark Street, RHCE
http://www.oswizards.com
--
Key fingerprint = 3949 39E4 6317 7C3C 023E  2B1F 6FB3 06E7 D109 56C0
GPG key http://www.oswizards.com/pubkey.asc