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

How does a cursor work?

994


How to execute stored procedure in db2 command editor?

1053


What is dclgen in db2?

1153


What is check constraint. Explain with example.

1114


is it compulsory commitment control in journal?

2483


What are the benefits of using the db2 database?

1235


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1081


How to run db2 command in windows?

1199


What is the syntax for seeing the columns and data types of a table in the db2 database?

1171


What is innodb buffer pool?

1063


How can we read records for specific member in CL? AND rpg?

706


Is schema the same as database?

1062


How can you do the explain of a dynamic sql statement?

1072


What is the information associated with sysibm.syslinks table?

1129


How to create db2 table in mainframe?

1158