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
What is null indicator in db2?
How is a typical db2 batch pgm executed?
What language is db2 written in?
What is temporal table in db2?
What are the bind parameters ibm db2?
How do you find the maximum value in a column in db2?
Comment whether the cursor is closed during commit or not.
What is the difference between nvl and coalesce?
What is reorg and runstats in db2?
Why select is not preferred in embedded sql programs?
Is db2 free?
What is page size in db2?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is buffer pool?
What is dbrm library?