FW: Best Way to find duplicate records in same file

["Elvis Budimlic" <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx>]

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