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
- 32538 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
What is the contrast amongst drop and truncate?
What is partition in sql server?
List some advantages and disadvantages of stored procedure?
Do you know what are acid properties of transaction?
Are semicolons required at the end of sql statements in sql server 2005?
Do I need a report server to run reports in my application?
Why are views required in the sql server or in any other database?
What are the disadvantages of merge replication?
what's the difference between a primary key and a unique key? : Sql server database administration
Explain about Views?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
What is a matrix in ssrs?
How to join two tables in a single query in ms sql server?
How to find the service pack installed? : sql server database administration
What is sql server english query?
