Interested to Buy Any Domain ? << Click Here >> for more details...
In a single table,How to retrieve a employee-id of an
employee who works in more than one department?
- 15 Answers
- 23517 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / g.kameswara reddy
select employee_id from employee table where department in
('a1','a2','b1','b2');
| Is This Answer Correct ? | 7 Yes | 11 No |
Post New Answer View All Answers
What is load replace in db2?
Which isolation level provides highest data integrity?
Is db2 a mainframe?
What is the difference between spufi and qmf?
How do I add a column in db2?
How to access db2 tables in mainframe?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
B37 abend during spufi?
What do you mean by between and in? Is between inclusive of specified range values?
Is db2 relational database?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is the role of schema in the db2 database?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is database reorganization?
How to find the maximum value in a column in the db2 database?
