i want to delete the duplicate rows in s table based on few columns, with out using temp table; I have a table x and I have column a,b,c,d,e,f,g. i have no constraints in the table and i want to add constraints to the able for that, i have to delete the duplicate records in the table x. its working ...