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

select employee-id
from table-name
grtoup by employee-id
having count(*) > 1

Is This Answer Correct ?    13 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an instance database?

1059


What is db2 purescale?

1012


What is reorg and runstats in db2?

1223


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

1082


What is table space in db2?

1025


What is the picture clause of null indicator variable?

1139


List down the types of triggers in the db2 database?

1035


i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2538


what are bind concepts in db2 cobol?

1099


What is performance tuning db2?

1068


Mention some fields that are a part of sqlca.

1043


Why do chiropractors use drop table?

1114


What are the contents of a dclmgen?

1135


Explain the benefits you can get from mainframe connect?

974


What is bind and rebind in db2?

1142