In a single table,How to retrieve a employee-id of an
employee who works in more than one department?
Answer Posted / sri
select A.empid from EMP A, EMP B where
A.empid = B.empid and
A.dept not = B.dept
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Differentiate between cs and rr isolation levels? Where do you specify them?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What are the full forms of spufi and dclgen and why are they used?
Explain the contents that are a part of dclgen.
What is the difference between nvl and coalesce?
What is ibm db2 database?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is a dbrm in db2?
What is a db2 cursor?
What is explain plan in db2?
What is blu acceleration in db2?
What r the comman abends in db2, jcl and cobol???????
What is iseries database?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
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?