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
what are the disadvantages of cursors? : Sql server database administration
When we should use and scope of @@identity?
Do you know what is sql service broker?
What is the purpose of a table?
Define the one-to-one relationship while designing tables.
What are sub reports?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
New concepts of sql server 2005 use in your project.
Define outer join in sql server joins?
Explain what is lock escalation?
How to bind a view to the schema of the underlying tables?
In what three ways is the return statement used in a stored procedure?
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
on line cluster can we make if yes tell me the procedure