|
Just a question, will this not work ? 1. try a rpg-II cycle CL0NL1 DELETRECORD Narayanan R Pillai ----- Original Message ----- From: "Elvis Budimlic" <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx> To: "'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx> Sent: Friday, May 09, 2003 1:55 PM Subject: FW: Best Way to find duplicate records in same file > Correction, not ordered table, but only distinct. > > To get the ordered table you'd need to user ORDER BY clause. > > -----Original Message----- > > SELECT DISTINCT * FROM NEWTABLE > > Will give you only distinct rows in your table. You can take this > further by creating a view (sort of like non-keyed LF) by: > > CREATE VIEW QTEMP/VIEW1 AS SELECT DISTINCT * FROM NEWTABLE > > And then you can access it as an ordered table. > > Elvis > > > > > _______________________________________________ > 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.cgi/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.