Interested to Buy Any Domain ? << Click Here >> for more details...
How to retrieve duplicate rows in a table?
How to delete the duplicate entries in a table?
- 15 Answers
- 33060 Views
- Leo Technologies, Mannar Company, Synechron, I also Faced
- E-Mail Answers
Answer Posted / skybeaver
/* selecting duplicate rows in a table */
select col1, col2, ..., colN, count(*)
from TableName
group by col1, col2, ..., colN
having count(*) > 1
/* deleting duplicate rows from a table */
select col1, col2, ..., colN, count(*) as "Duplicates"
into #duplicates
from TableName
group by col1, col2, ..., colN
having count(*) > 1
delete TableName
from TableName t, #duplicates d
where t.col1 = d.col1 and
....
t.colN = d.colN
/* damn I'm good! */
| Is This Answer Correct ? | 11 Yes | 5 No |
Post New Answer View All Answers
What do we need queues in sql service broker?
What are difference between Cluster index and Non-Cluster index?
What is the difference between getdate and sysdatetime?
You want to use a perspective in an mdx query. How do you select the perspective?
What are the types of joins in sql?
List some case manipulation functions in sql?
How to send a ssrs report from ssis?
How do you create a data source?
How to execute stored procedure and set temp table in sql server?
Why variables called the most powerful component of ssis?
Explain query editor regions
Explain what is sql server english query?
How many types of functions are there in sql server?
How to select true false based on column value in sql server?
Can we insert data if clustered index is disabled?
