Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10940 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 happens to a trigger with multiple affected rows?
How do you handle datasets larger than 50 gb?
Explain what are the events recorded in a transaction log?
what are constraints? : Sql server database administration
What is a periodical index?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
What is log cache in sql server?
Why use “pivot” in sql server?
Explain what is sql server english query?
How is SQL Azure different than SQL server?
What is the difference between a unique key and primary key?
How to transfer an existing table from one schema to another schema in ms sql server?
How to send email from database?
How to use linked server?
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
