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
- 9789 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 is the cartesian product of table?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
What are the basic functions for master, msdb, model, tempdb and resource databases?
What is join query?
What happens if the update subquery returns multiple rows in ms sql server?
What are sql server procedures?
How to delete database objects with "drop" statements in ms sql server?
What is the difference between coalesce() & isnull()?
What is the order in which the sql query is executed?
How do we Backup SQL Azure Data?
Explain what is the main purpose of having conversation group?
Why we need sql server?
How to insert multiple rows with a subquery?
Can you leave a union at any time?
Can group by be used without aggregate functions?
