In a single table,How to retrieve a employee-id of an
employee who works in more than one department?
Answer Posted / krishnakumar
select employee-id
from table-name
grtoup by employee-id
having count(*) > 1
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
What is an instance database?
What is db2 purescale?
What is reorg and runstats in db2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is table space in db2?
What is the picture clause of null indicator variable?
List down the types of triggers in the db2 database?
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?
what are bind concepts in db2 cobol?
What is performance tuning db2?
Mention some fields that are a part of sqlca.
Why do chiropractors use drop table?
What are the contents of a dclmgen?
Explain the benefits you can get from mainframe connect?
What is bind and rebind in db2?