I just want to know how do we delete duplicate rows in a table. There is no Primary key is defined in the table. For eg., 1001 XXXX 25 FINANCE 1002 YYYY 27 TESTING 1003 ZZZZ 28 FINANCE 1004 AAAA 29 HR 1001 XXXX 25 FINANCE 1005 BBBB 30 HR 1006 CCCC 27 TESTING
From the above the record 1001 was repeated twice and I Just want to delete only one row. And another copy to be remain in the table.
Thanks Steve. Is there any way to Extract the table data into a file without using Application Program like COBOL etc.,? Is there anything we can do with SPUFI/QMF to Extract table content into a file??