How to delete duplicate records from a table?(for suppose in
a table we have 1000 Records in that we have 200 duplicate
Records , so ,how to findout that duplicate Records , how to
delete those Records and arranged into sequence order? one
more thing that there is no primary key at all)
- 5 Answers
- 9096 Views
- Infosys, McAfee, I also Faced
- E-Mail Answers
Answer Posted / sneha
select distinct * from table into new_table;
delete table;
select * from new_table into table;
| Is This Answer Correct ? | 8 Yes | 6 No |
Post New Answer View All Answers
What are the types of database recovery models?
State the difference between local and global temporary tables?
What is difference between commit and rollback when used in transactions?
What is difference between equi join and inner join?
What is self contained scalar sub query?
How to return the second 5 rows in ms sql server?
How to execute stored procedure and set temp table in sql server?
How many types of subqueries are there in sql server?
What is an entity-relationship diagram (erd)?
How to identify current user in ssrs report?
How to turn off warning messages during php execution?
Explain logical operators in sql server?
List few advantages of stored procedure.
What is compound operators?
Difference between aggregate functions of sql?
