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 / sri

select A.empid from EMP A, EMP B where
A.empid = B.empid and
A.dept not = B.dept

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is null indicator in db2?

1122


How is a typical db2 batch pgm executed?

1185


What language is db2 written in?

1053


What is temporal table in db2?

1047


What are the bind parameters ibm db2?

1058


How do you find the maximum value in a column in db2?

1111


Comment whether the cursor is closed during commit or not.

1112


What is the difference between nvl and coalesce?

1069


What is reorg and runstats in db2?

1226


Why select is not preferred in embedded sql programs?

1309


Is db2 free?

1100


What is page size in db2?

986


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.

2730


What is buffer pool?

1110


What is dbrm library?

1077