Difference between join and a subquery?

Answer Posted / rajasekhar

sub query: it is a query to get the answer for multiple questions


joins: it is used for getting the data from more then two tables

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the components of logical database structure in oracle database?

584


How to rename an existing table?

611


Is there an oracle sql query that aggregates multiple rows into one row?

547


How to drop an index?

546


Does oracle partitioning improve performance?

552






interview questions with answer for cts

2090


How to start your 10g xe server from command line?

548


What is an oracle user role?

570


Is oracle a relational database?

524


How to speed up webrick?

598


What are the different types of modules in oracle forms?

564


What is the difference between postgresql and oracle?

508


How do I use os authentication with weblogic jdriver for oracle and connection pools?

577


Why we use bulk collect in oracle?

538


What is a lookup table in oracle?

543