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
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is dpf in db2?
What is a page in db2?
Why do we use cursor?
What is dclgen in db2?
What is alias in db2?
What is a plan and package in db2?
What is node in db2?
List out the data types available.
What is a bind card?
What is difference between isnull and coalesce?
What are the benefits of using the db2 database?
Mention the definition of cobol in varchar field.
Can you use max on a char column?
What is the difference between oracle and db2?