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 a rule be bound to any column of any data type?
Does server sql treat char as a variable-length or fixed-length column?
What are the functions in sql server?
How to get a list of columns in a view using the "sp_help" stored procedure?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
What is difference between rownum and rowid?
How to test odbc dsn connection settings?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
What is autocommit mode in sql server?
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
Is truncate a dml command?
Why are you getting errors when creating a new odbc dsn?
What is the maximum size of sql server database?
Explain data warehousing in sql server?
What is the simplest way to create a new database in ms sql server?