SQL-Select and Delete

Posted in 1997

Chengteh Lee — Fri, 28 Feb 1997 11:15:53 -0600 — source: Informix-list mailing list archive (1991-1998)

A friend of mine asked how to use a compound sql to delete old records and keep the latest in a table? Thanks! Chengteh Lee example: a table with 2 col. col1 col2 1 Kevin (Delete) 2 John (Delete) 3 Kevin (Delete) 4 Kevin (Keep) 6 John (Delete) 5 John (Keep) .... .... .... ------------------------------------------------------------ AcuStaf Corporation Automated Staffing Systems 5001 West 80th Street Payroll, Scheduling Minneapolis, MN 55437 Time/Attendance ... 612-831-4122 ext 248 http://www.acustaf.com ------------------------------------------------------------