Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

Answer Posted / ram.g

ans 5 need to be corrected...

subquery will fetch correct result but main query hw it
will compare... ???

it supposed to be where eid exists(select eid...where
e1.eid= e2.eid)

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is consistency token in db2?

1061


How do I connect my db2 database to ibm?

985


Explain about rct in db2?

1044


Is schema the same as database?

1006


What are concurrency issues?

1029


What is the reason behind not using select * in embedded sql programs?

1044


Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2667


What are the various isolation levels possible?

1048


What are the full forms of spufi and dclgen and why are they used?

1023


What is drop table?

959


What is release/acquire in bind?

1057


What is universal database?

1029


What is cursor with hold option in db2?

1010


What types of tables are there in the db2 database?

1005


What is the picture clause of null indicator variable?

1081