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
- 24159 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / krishnakumar
Ans 5 is also correct but it seems a bit compliceted
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is ibm db2 used for?
How and when does the db2 enforces the unique key?
What is the use of predicate?
What is copy pending and check pending in db2?
What is the use of value function?
How can you quickly find out the # of rows updated after an update statement?
How do I add a column to an existing table in db2?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
How to check sequence on a table in db2?
How will you return the number of records in table?
What is the physical storage length of time data type?
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.
List out the buffer pools in db2
What are the different types of base tables?
What is the physical storage length of date data type?
