Why use subqueries instead of joins?


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

Post New Answer

More SQL PLSQL Interview Questions

I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for each deptno?

8 Answers   L&T,


What is the unique index?

0 Answers  


Explain the order of sql statement execution?

0 Answers  


What are data types in pl sql?

0 Answers  


Explain what is sql*plus?

0 Answers  


Why are indexes and views important to an organization?

0 Answers  


how to enter binary numbers in sql statements? : Sql dba

0 Answers  


What do you know by pl/sql cursors?

0 Answers  


Explain the usage of WHERE CURRENT OF clause in cursors ?

3 Answers  


What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.

5 Answers   Polaris,


can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)

5 Answers  


What are the modes of parameters that can be passed to a procedure ?

3 Answers  


Categories