|
That's interesting...the first SQL statement (the SELECT) shows a bunch of dup rows, the second SQL statement (the DELETE) says no rows found. > -------- Original Message -------- > Subject: Re: Delete Duplicate Rows > From: rob@xxxxxxxxx > Date: Wed, September 14, 2005 12:33 pm > To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx> > > http://tinyurl.com/b86rz > http://www.as400network.com/artarchive/index.cfm?fuseaction=viewarticle&CO_ContentID=14940&channel=art&subart=top&topicid=51 > > Rob Berendt > -- > Group Dekko Services, LLC > Dept 01.073 > PO Box 2000 > Dock 108 > 6928N 400E > Kendallville, IN 46755 > http://www.dekko.com > > > > > > michael@xxxxxxxxxxxxxxxxxx > Sent by: midrange-l-bounces@xxxxxxxxxxxx > 09/14/2005 11:20 AM > Please respond to > Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx> > > > To > midrange-l <midrange-l@xxxxxxxxxxxx> > cc > > Subject > Delete Duplicate Rows > > > > > > > How can I delete duplicate rows in Interactive SQL? I know how to find > them...I don't know how to delete all the dups and just leave one row > in a group. > > TIA... > > -- > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing > list > To post a message email: MIDRANGE-L@xxxxxxxxxxxx > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/midrange-l > or email: MIDRANGE-L-request@xxxxxxxxxxxx > Before posting, please take a moment to review the archives > at http://archive.midrange.com/midrange-l. > > > -- > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list > To post a message email: MIDRANGE-L@xxxxxxxxxxxx > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/midrange-l > or email: MIDRANGE-L-request@xxxxxxxxxxxx > Before posting, please take a moment to review the archives > at http://archive.midrange.com/midrange-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.