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

Does sql backup shrink transaction log?

0 Answers  


What is 19 null in sql?

0 Answers  


Where is sql database stored?

0 Answers  


Why is normalization important?

0 Answers  


Is primary key always clustered index?

0 Answers  


1.when will you use week refcursor and when will you use strong ref cursor ? 2.what is the use of sql trace..how do you use it ? 3.can you please send all the sql plus commands...like set line 6000....

1 Answers   Satyam,


how to retrieve the top 2 salaried persons from a database?

7 Answers   Orion Laboratories,


How well can multiple sessions access the same data simultaneously ?

1 Answers   Oracle,


How to write html code in pl sql?

0 Answers  


What are the basic techniques of indexing?

0 Answers  


i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.

2 Answers   IBM, Loginworks, OFSS,


Explain the PL/SQL compilation process.

3 Answers  


Categories