In a single table,How to retrieve a employee-id of an
employee who works in more than one department?
Answer Posted / ram.g
ans 5 need to be corrected...
subquery will fetch correct result but main query hw it
will compare... ???
it supposed to be where eid exists(select eid...where
e1.eid= e2.eid)
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How does a cursor work?
How to execute stored procedure in db2 command editor?
What is dclgen in db2?
What is check constraint. Explain with example.
is it compulsory commitment control in journal?
What are the benefits of using the db2 database?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
How to run db2 command in windows?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is innodb buffer pool?
How can we read records for specific member in CL? AND rpg?
Is schema the same as database?
How can you do the explain of a dynamic sql statement?
What is the information associated with sysibm.syslinks table?
How to create db2 table in mainframe?