del dup recs

Hello! Software: On-line 4.0 OS: Interactive Unix 3.2 Problem: Duplicate data in (supposedly) unique columns. Question: How do I remove the records with duplicate ssn columns if my data file has about 25,00 recs of which 8,000 ssn's are dups (according to a select count(distinct ssn), but data in the other columns may be different? i.e. +----------+---------+--------------+ |name |ssn |address | +----------+---------+--------------+ |fred |121212121|who cares | |fred Jr. |121212121|I sure don't | |tony |131313131|don't know | +----------+---------+--------------+ Thanks! Ray /////////////////////////////////////////////////////////////////////////////// // Ray Storer; SGT, US Army; Software Engineer, TM LDR // // E-mail: eapc-amo2@emh7.korea.army.mil // // US Mail: HHC, 8TH PERSCOM;UNIT: 15316 ATTN: IMO;APO AP 96205 // // Voice/FAX: 011-82-2-791-43359 // // * Disclaimer: Opinions expressed are mine and do not, in any way, reflect // // * US Gov., Army, DOD or anyone else's opinions or policies. // ///////////////////////////////////////////////////////////////////////////////