Q3. How will you fetch duplicate values from a DB2 table?
- 2 Answers
- 14231 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
If I have a view which is a join of two or more tables, can this view be updateable?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is the difference between db2 and oracle?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Why do chiropractors use drop table?
What is the physical storage length of the data types date, time, and timestamp?
How do I import a csv file into db2?
What are types of indexes?
What are union and union all?
What does db2 mean?
How to find schema of a table in db2?
What do you mean by commit and rollback?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is a bind card?
