How to retrieve duplicate rows in a table?
How to delete the duplicate entries in a table?
- 15 Answers
- 29199 Views
- Leo Technologies, Mannar Company, Synechron, I also Faced
- E-Mail Answers
Answer Posted / madhur/amrutha
Consider a table emp with employee details. The Correct
code to retrieve duplicate rows :
select distinct * from emp where names in
(select names from emp group by names having count(sal)>1)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are indexers?
What is application role in sql server database security? : sql server security
What do you mean by a dependent functionality in a build?
System requirements for sql server 2005 express edition?
Different types of keys in SQL?
What are various aggregate functions that are available?
Scalability, Availability, Integration with internet, etc.)?
How do I create an extended event in sql server?
What are information schema views?
What are window functions in sql server?
Which sql server is best?
What are parameterized reports? What are cascading parameters in ssrs reports?
What are clustered and non-clustered index?
Which command is used for user defined error messages?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
