This content has been marked as final. Show 2 replies
that was correct.
better u provide small peice of data how u have.:where u getting non duplicate row.
What is the desired output??
Do you want to see only unique records??
Or you want to see the duplicate records.
Giving an example will make it easier to provide the required querty.
BTW here is an simple query which is used to delete the duplicate records and keep the unique records in table.
DELETE FROM table_name a WHERE EXISTS (SELECT 1 FROM table_name b WHERE a.sv_id = b.sv_id AND a.sv_detail_id = b.sv_detail_id AND a.ROWID > b.ROWID );