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 are the differences between Database Trigger and Integrity constraints ?

2 Answers   Synergy,


What is a Transformation?

0 Answers   Informatica,


aht is the difference b/w network & hierarchial & relational dbms????

0 Answers  


please tell me the informatica telecom projects interview question? like if they ask about project explanation and the difficulties and the solutions taken to solve the issues for telecom projects,e.g i am workin for a vodafone project handlin postpaid section,pls tell me wat wud be the process if i work in this ? thanks

0 Answers  


What is ole db ado?

0 Answers  


What is redis good for?

0 Answers  


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

0 Answers   Cap Gemini,


First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9

0 Answers   IBM,


What is ase database?

0 Answers  


How do you select an index for a table

1 Answers  


What is lagging in DBMS ?

0 Answers   Hexaware,


Why merge statement is used inside the database?

0 Answers   ADITI,


Categories