× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.






Thanks Mark, that worked!  Thanks too to Rob for the list of SQL commands.
I may need some of them shorthly.


Dave Parnin
--
Nishikawa Standard Company
Topeka, IN  46571
daparnin@xxxxxxxxxxxxxx



                                                                                
                                 
                      "Mark Walter"                                             
                                 
                      <mwalter@xxxxxxxxxxx        To:       "Midrange Systems 
Technical Discussion"              
                      >                            <midrange-l@xxxxxxxxxxxx>    
                                 
                      Sent by:                    cc:                           
                                 
                      midrange-l-bounces@m        Subject:  RE: Extracting 
distinct rows into a new file via SQL 
                      idrange.com                                               
                                 
                                                                                
                                 
                                                                                
                                 
                      03/20/2006 11:29 AM                                       
                                 
                      Please respond to                                         
                                 
                      Midrange Systems                                          
                                 
                      Technical Discussion                                      
                                 
                                                                                
                                 




CREATE TABLE MyNewTbl as (SELECT DISTINCT myField FROM MyOldTbl) WITH
DATA


Mark Walter
Senior Programmer/Analyst
IBM Certified RPG Developer
Hainey Business Systems
(717) 771-2362
mwalter@xxxxxxxxxxx
http://www.hbs-inc.com


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
daparnin@xxxxxxxxxxxxxx
Sent: Monday, March 20, 2006 11:19 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Extracting distinct rows into a new file via SQL





Can I use SQL to create a table from another table but without duplicate
records?  I've got a one-field file that has numbers like
140645
140647
140647
140647
140648
140648

I can do a SELECT DISTINCT * FROM ORDERLIST to get
140645
140647
140648
140649
but I would like to either put these into a new file or delete the dups
from the original file.  Any thoughts would be appreciated.


Dave Parnin
--
Nishikawa Standard Company
Topeka, IN  46571
daparnin@xxxxxxxxxxxxxx

--
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 thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.