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
- 10944 Views
- Infosys, McAfee, I also Faced
- E-Mail Answers
Answer Posted / sirisha
with numbered as(select rowno = row_number() over(partition
by empid order by empid),empname from employee)delete from
numbered where rowno > 1
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
What is the difference between DATETIME2 and DATETIME?
How can we solve concurrency problems?
What is the difference between for trigger and after trigger?
Why do we use functions?
What is local temp table?
What is clustered index
What type of locking occurs during the snapshot generation? : sql server replication
Are all views updatable ?
What is the web service used for reporting services?
What's new in sql management studio for sql server? : sql server management studio
What is order of B+tree?
What are the three different part of rdl file explain them?
What is acid db?
How will you add a dimension to cube? : sql server analysis services, ssas
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
