how to delete duplicate rows from a specified table(only
single table)
how do you know which join is need to be used
Answer Posted / raghavendraprasad
delete from table_name where rowid not in (select max
(rowid) from table group by duplicate_values_field_name);
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
what are the features and advantages of object-oriented programming? : Sql dba
How do I remove sql developer from windows 10?
What is delimiter in pl sql?
What are the built in functions of sql?
What is a recursive stored procedure?
How is a PL/SQL code compiled?
What are the two types of cursors in pl sql?
Which join condition can be specified using on clause?
Is primary key always clustered index?
what is single byte over head in oracle..?
What are the operators in sql?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
What are different types of tables in sql?
What is an intersect?
Can you sum a count in sql?