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
What is the usage of open cursor command?
What is scrollable cursor in db2?
Explain the function of data manager.
What is dpf in db2?
Define data page.
What is bufferpool in db2?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is db2 catalog database?
Why do chiropractors use drop table?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
Explain the benefits you can get from mainframe connect?
How to create backup table in db2?
what is the role of the cursor in db2?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What do you mean by rollback?