Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to delete duplicate records in SQL SERVER
- 36 Answers
- 77885 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / skumar
Hi friends, please just try out this. This works fine for me.
We have lot of methods to do this. But using temp table,
drop the original table,retain the temp as orinial is not a
good pratice.
When u have large no of data it will affect ur performance.
DELETE FROM employee WHERE((SELECT eid,COUNT(eid) FROM
employee GROUP BY eid) > 1)
| Is This Answer Correct ? | 15 Yes | 46 No |
Post New Answer View All Answers
What are the kinds of subquery?
Where can you add custom error messages to sql server?
What are different types of constraints?
How to convert numeric expression data types using the cast() function?
How to connect php with different port numbers?
What is a scheduled job or what is a scheduled task?
Can one drop a column from a table?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
Can sql servers link to other servers like oracle?
what is the difference between openrowset and openquery?
Explain “row_number()” in sql server with an example?
What is an indexed view?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
Why use identity in sql server?
Why should you use or avoid select * statements?
