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
- 33030 Views
- Leo Technologies, Mannar Company, Synechron, I also Faced
- E-Mail Answers
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
Write a query for primary key constraint with identity key word?
What is database isolation in sql server? : sql server database administration
How do I create a stored procedure in sql server?
What is mssql?
How to view existing indexes on an given table using sys.indexes?
What are the tool windows in sql server management studio? : sql server management studio
How to write character string constants or literals in ms sql server?
Create and insert into temp table in sql server?
Explain mixed authentication mode of sql server?
Can you explain different types of joins?
What is function of CUBE ?
What are drillthrough reports?
How to resolve the orphan use problem? : sql server security
What is format parameter in ssrs?
Explain the categories of stored procedure?
