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
- 32652 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 are defaults? : Sql server database administration
Write a program to fetch first 10 records from a file?
What is the primary use of the model database?
How to backup encryption key ?
How many partitions a clustered index has by default in sql server 2012?
What is collation?
What is the difference between osql and query analyzer?
What is the fastest way to permanently delete a 1 million row table named customers?
which table keeps the locking information? : Sql server administration
Which language rdl files made of?
What are two difference between sql azure and azure tables?
What are “phantom rows”?
How to loop through the result set with @@fetch_status?
Explain different types of collation sensitivity?
What is the need for group functions in sql?
