Hi Masters,
HISTORY:= “ I was challenged by my senior to delete duplicate data without using subquerry.”
I have been trying to delete from table cust(cust_id)
using equi join using query.
Select is working but delete doesn't work.
Assuming structure [cust_id, cust_name]
data: [[1,"GOKU"],[1,"GOKU"]]
select a.* ,a.rowid,b.rowid from cust a , cust b where a.cust_id = b.cust_id and a.row_id < b.row_id;
delete from cust a , cust b where a.cust_id = b.cust_id and a.row_id < b.row_id;