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
- 23755 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is explain plan in db2?
What is the maximum number of columns in a db2 table?
How and when does the db2 enforces the unique key?
How to find the number of rows in a db2 table?
Explain in detail about buffer manager and its functionalities?
What is the usage of open cursor command?
What is copy pending status in db2?
Explain package in db2 and its advantages?
List out the buffer pools in db2
How many databases are there?
What is the meaning concurrency in the db2 database?
What type of database is db2?
What is the reason behind not using select * in embedded sql programs?
Highlight all the advantages that are attached to a package.
