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
- 24128 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / manikandan.d
hi all i hope this answer will help you
emp
eid ename dep
001 manikandan mainframe
002 karthi java
003 jarin mainframe
001 manikandan java
003 jarin testing
004 hariharan java
001 manikandan testing
select eid from emp e1 where 1 <
(select count(*) from emp e2 where e1.eid=e2.eid)
let me know if any new answer
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
What are the prerogatives?
What is host variable in db2 cobol?
can all users have the privilage to use the sql statement select * (dml)?
Is the primary key a clustered index?
How to find the number of rows in db2 tables?
How does cobol compile db2 program?
What is reorg?
Is db2 a mainframe database?
What is the use of predicate?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What types of tables are there in the db2 database?
On which levels locks can be applied?
Why do we need reorg in db2?
How do you pull up a query which was previously saved in qmf?
What does db2 mean?
