In a single table,How to retrieve a employee-id of an
employee who works in more than one department?
Answer Posted / prasenjit_in
Select emp_id from employee where dept IN (select all
dept from employee);
| Is This Answer Correct ? | 4 Yes | 9 No |
Post New Answer View All Answers
What are the various isolation levels possible?
What is the physical storage length of date data type?
What's The Error Code For Unique Index Voilation?
Is db2 a programming language?
What do you mean by storage group (stogroup)?
How to find the number of rows in a db2 table?
How do we specify index to include or not during bind process.
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
How to restart a DB2 program?
What is the difference between nvl and coalesce?
Give the name of some fields form sqlca.
What is the maximum size of a char data type in db2?
How do I add a column to a table in db2?
What are union and union all?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2