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
- 10913 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
How to execute a sql statement using mssql_query()?
Explain multiserver query
Explain the different types of joins?
Do I need a report server to run reports in my application?
Explain nested trigger in sql?
What is mean by dml?
Is oracle faster than sql server?
How to test a dml trigger in ms sql server?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
please differentiate between delete and truncate?
Which tools are available to manage SQL Azure databases and servers?
How do you create an execution plan?
Explain tables in SQL Azure?
What is the difference between the application object and session object?
Where in ms sql server is ’100’ equal to ‘0’?
