Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete duplicate rows from a specified table(only
single table)
how do you know which join is need to be used
- 11 Answers
- 18840 Views
- UST, I also Faced
- E-Mail Answers
Answer Posted / jas
delete from table_name where rowid > (select min(rowid)
from table_name where a.col_name=b.col_name)
create new_table as select distinct * from table_name;
drop table_name;
create table_name as select * from new_table;
drop new_table;
delete from table_name where rowid not in (select max
(rowid) from table_name where a.col_name=b.col_name)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what are the disadvantages of mysql? : Sql dba
What are the types of subqueries?
What is the reports view in oracle sql developer?
What is plpgsql language?
what is offset-fetch filter in tsql? : Transact sql
What is the basic form of sql query?
What is group function in sql?
What is the use of desc in sql?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
what is a field in a database ? : Sql dba
How does sql developer connect to oracle database?
How do you delete duplicates in sql query using rowid?
Explain isolation levels. : Transact sql
What is the advantage of index in sql?
How do I count records in sql?
