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)
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
Can you explain powershell included in sql server 2008?
What are the advantages of passing name-value pairs as parameters?
what is raid? : Sql server database administration
Explain indexed views and partitioned view with their syntax.
Which tools are available to manage SQL Azure databases and servers?
Explain what are the restrictions while creating batches in sql server?
How to find out the list schema name and table name for the database?
What is user-defined scalar function?
What is ddl and dml commands?
How do I open port 1433?
Explain a differential backup?
How to skip remaining statements in a loop block using continue statements?
Define outer join?
What is normalization and what are the advantages of it?
What does indexation mean?