i want to delete the duplicate rows in s table based on few columns, with out using temp table
Posted: Thu Aug 31, 2017 1:11 pm
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 fine if i am using the temp table and for security purpose i should not use this.
please advise
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 fine if i am using the temp table and for security purpose i should not use this.
please advise