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
- 10931 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
Give an example of SQL injection attack ?
What is the cpu pressure?
Where the sql logs gets stored? : sql server database administration
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
What command do we use to rename a db, a table and a column?
What are the disadvantages of using querystrings to send data from one page to another?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
What is truncate table?
Define right outer join in sql server joins?
Tell me the phases a transaction has to undergo?
How to transfer data from a cursor to variables with a "fetch" statement?
Can sql server 2016 run on windows 7?
Define full outer join?
What is database dimension? : sql server analysis services, ssas
What is row_number function?
