What is the SQL query to select, delete and get count of
duplicate rows in DB2?
Answer Posted / hkhatri27
SELECT Columns
FROM Table
GROUP BY Columns
HAVING COUNT(*) > 1;
~ Himanshu
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is cursor stability in db2?
Define db2 and its databases?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
Explain what are the various isolation levels possible?
What is with ur in db2?
What are the full forms of spufi and dclgen and why are they used?
What is a collection in db2?
How do you stop a db2 database in linux?
How to compare data between two tables in db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
How to check table size in db2 sap?
How do I start db2 in windows?
How do I import a csv file into db2?
What is package in cobol db2?
What is the use of commit in db2?