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 Lock Based Protocol used for?

0 Answers   Hexaware,


Can we use redis as database?

0 Answers  


List some advantages of dbms.

0 Answers  


What do you mean by database?

0 Answers  


How do you select an index for a table

1 Answers  






If the master device is full, how do I make the master database bigger?

0 Answers  


write a query for the fifth highest salary?

17 Answers   IBM, Matlabs, Ramco,


What is the database url?

0 Answers  


Integrity constraints means..? how many and what are they?

4 Answers   AZTEC,


what is vlook up in ms excel and how does it used???

1 Answers   CybAge,


On startup, the transaction log of a database has filled and recovery has suspended, what can I do?

0 Answers  


Under which circumstance should you create an index on a table?

0 Answers   3i Infotech,


Categories