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
- 10672 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 create a login account in ms sql server to access the database engine using "create login" statements?
What is dknf in normalization form?
Find columns used in stored procedure?
How to provide default values to stored procedure parameters?
What does the not null constraint do?
What is the difference between stored procedure and functions?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
What is log ldf?
How does the report manager work in SSRS?
Do you know what are acid properties?
Explain the use of keyword with encryption. Create a store procedure with encryption?
Which are new data types introduced in sql server 2008?
Explain what is lock escalation?
Why olap is used?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
