Interested to Buy Any Domain ? << Click Here >> for more details...
Suppose there are many duplicate records in a Db2 table.
What is the query to retrive only duplicate records?
- 4 Answers
- 8933 Views
- I also Faced
- E-Mail Answers
Answer Posted / gouri
select column_1 from tablename groupby column1 having coun(*)>1
| Is This Answer Correct ? | 11 Yes | 4 No |
Post New Answer View All Answers
Is db2 a mainframe?
What language is db2 written in?
What do you mean by storage group (stogroup)?
What is cursor in dbms?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
How to resolve deadlock issue
What is a cursor in programming?
What is ibm db2 client?
What is ibm db2 database?
Why do we need reorg in db2?
Mention some fields that are a part of sqlca.
When do you specify the isolation level?
Why do we use cursor?
What is db2 catalog database?
Comment whether the cursor is closed during commit or not.
