Re: SOS-HELP !!!!!

delete from mytable
where rowid not in
(select min
 rowid
 from mytable
 group by keycol1,keycol2...keycoln)
/

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!