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
- 23539 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / krishnakumar
select employee-id
from table-name
grtoup by employee-id
having count(*) > 1
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
What's The Error Code For Unique Index Voilation?
What is the information associated with sysibm.syslinks table?
Explain the contents that are a part of dclgen.
List out the buffer pools in db2
What is meant by explain?
What is runstats db2?
Can we delete records from view?
What are the different types of base tables?
What are the full forms of spufi and dclgen and why are they used?
What is concurrency?
What is db2 catalog database?
How to execute stored procedure in db2 command editor?
What is cascading rollback?
Explain package in db2 and its advantages?
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 .....
