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
- 11162 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
How many primary keys are possible in a table?
Explain the truncate command? : SQL Server Architecture
How to use subqueries with the in operators in ms sql server?
Explain how does the report manager work in ssrs?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
What is implicit mode in sql server?
What is report subscription?
How do you run a trace?
What are the differences between left join and inner join in sql server?
How to create a user name in a database?
What are different replication agents and what's their purpose? : sql server replication
What are the disadvantages of using the stored procedures?
What is a scheduled job or what is a scheduled task?
What is a mutating table error and how can you get around it?
What do we need queues in sql service broker?
