AW: Extracting distinct rows into a new file via SQL

["Hauser, Birgitta" <Birgitta.Hauser@xxxxxxxxxxx>]

Hi,

what about:

Create Table MySchema/NewTable
    As (Select Distinct * From OrderList)
With Data

Birgitta

"If you think education is expensive, try ignorance"
(Derek Bok)
 
-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von
daparnin@xxxxxxxxxxxxxx
Gesendet: Montag, 20. März 2006 17:19
An: midrange-l@xxxxxxxxxxxx
Betreff: 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