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

What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?

2 Answers  


what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

0 Answers  


What is sql trigger example?

0 Answers  


Can we join more than 2 tables in sql?

0 Answers  


need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

2 Answers  






Why is %isopen always false for an implicit cursor?

0 Answers  


What is multiple partition?

0 Answers  


What is the need of a partition key?

0 Answers  


What is rank () in sql?

0 Answers  


How well can multiple sessions access the same data simultaneously ?

1 Answers   Oracle,


What is a procedure in pl sql?

0 Answers  


what does the t-sql command ident_incr does? : Transact sql

0 Answers  


Categories