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...


Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Databases AllOther Interview Questions

what is the full procedure for using store procedure in informatica7.1?

0 Answers  


Explain transaction manager?

0 Answers  


sparse lookup and where its options we find in OCI and db2?

0 Answers   TCS,


How do I manually create a database?

0 Answers  


How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?

0 Answers  


What are the types of joins?

0 Answers   Tavant Technologies, Zensar,


Explain buffer manager?

0 Answers  


What is the use of default key?

0 Answers   Abacus,


What is ole db provider for sql server?

0 Answers  


define primary key index, bitmap index, hash index,virtual indwx

0 Answers   Cap Gemini,


Differentiate between unique key and foreign key?

0 Answers   CGI,


how do you do sql tuning?

0 Answers   Systel,


Categories