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
- 23537 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 full forms of spufi and dclgen and why are they used?
Explain what are the various isolation levels possible?
What does sqlcabc has?
Outputs of explain are with matchcols = 0. What does this signify?
What is rct?
How do I import data from excel to db2?
How do you eliminate duplicate values in db2?
Which component is used to execute the sql statements?
What is host variable?
How to fetch the last row from the table in SQL (db2)?
What is bufferpool in db2?
What is access path in db2?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What are iseries servers?
How does coalesce work?
