Interested to Buy Any Domain ? << Click Here >> for more details...
Q3. How will you fetch duplicate values from a DB2 table?
- 2 Answers
- 14947 Views
- RBS, I also Faced
- E-Mail Answers
Answer Posted / ramana99
select City, Country, count('X') from Customers
group by City, Country
HAVING count('X') > 1
;
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is the information associated with sysibm.syslinks table?
What is null value in db2?
Which is faster delete or truncate?
How would you find out the total number of rows in a db2 table?
What are host variables in db2?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
How is deadlock resolved?
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 a dbrm in db2?
What is the clustering index in the db2 database?
Explain packages.
What is db2 bind process?
How to rename a table in DB2 ?
How to find schema of a table in db2?
