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 is unique key constraint? : Sql dba

0 Answers  


I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?

2 Answers  


write sub query for eliminating duplicate rows using analytical function?

3 Answers   Metric Stream,


How to run pl/sql statements in sql*plus?

0 Answers  


Explain what is an index?

0 Answers  






Can we join tables without foreign key?

0 Answers  


Does a join table need a primary key?

0 Answers  


How to run sql statements with oracle sql developer?

0 Answers  


How does one load ebcdic data? : aql loader

0 Answers  


Explain the order of sql statement execution?

0 Answers  


What is difference between ms sql and mysql?

0 Answers  


how to fetch alternate records from a table? : Sql dba

0 Answers  


Categories