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
- 19304 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 is the use of <> sql?
What is data manipulation language?
What is cursor and why it is required?
How to avoid duplicate records in a query?
What is package in pl sql with an examples?
How to select all records from the table?
Mention what pl/sql package consists of?
explain commit and rollback in mysql : sql dba
How can you load microsoft excel data into oracle? : aql loader
Which kind of parameters cannot have a default value in pl sql?
Can we use commit inside a trigger?
What is the file extension for sql database?
How do rank () and dense_rank () differ?
What are sql functions? Describe the different types of sql functions?
What are different methods to trace the pl/sql code?
