How to retrieve duplicate rows in a table?
How to delete the duplicate entries in a table?
Answer Posted / dilip
Ans for 1st Query
How to retrieve duplicate rows in a table?
SELECT * FROM EMP1 WHERE (EMP_ID IN (SELECT emp_id FROM
emp1 GROUP BY emp_id HAVING COUNT(emp_id) > 1))
Is This Answer Correct ? | 12 Yes | 3 No |
Post New Answer View All Answers
define and explain the differences between clustered and non-clustered indexes.
Does sql server 2016 have ssms?
How to use linked server?
What are the different types of Indexes available in SQL Server?
Can you explain full-text query in sql server?
What is the default port for SQL Server over a firewall?
What is query processing?
Explain what is lock escalation?
what are the reporting service components in SSRS?
How to delete duplicate rows?
What are orphan records?
What is the difference between writing data to mirrored drives versus raid5 drives
How much memory that we are using in Logshipping Concept?
What is dbcc command in sql server?
What are points to remember while using the fillfactor argument?