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

select emp-id from emp group by emp-id having count(*)>1;

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a Foreign Key?

1101


If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

2046


What is release/acquire in bind?

1109


What is null value in db2?

1029


How do I optimize a query in db2?

1104


What is cobol db2?

1003


What are db2 objects?

1051


What is cascading rollback?

1218


Why cursor is used in db2?

1038


What is the max length of sqlca?

1218


What is rebind in db2?

1071


What is host variable in db2 cobol?

1081


Explain about dbrm.

1051


What is the maximum size of varchar data type in db2?

1137


What is the result of open cursor statement?

1083