Difference between join and a subquery?

Answer Posted / maddy

Subquery is also query which returns one or more values we
can retriew the data based on the where contd="IN,ALL"...
subquery is the query followed by the main query....

join is used to join the two table is used to retriew the
data from 1 or more tables.....

Is This Answer Correct ?    27 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List out the difference between commit, rollback, and savepoint?

616


How to drop an existing view in oracle?

562


What is an oracle function?

595


what is the dual table in oracle?

549


How to update a table row with a record?

595






Explain about achiever in sql?

582


Explain constraining triggers.

593


Calculate difference between 2 date / times in oracle sql?

566


How to declare a local variable?

592


Explain drop constraint oracle?

589


normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

1736


What is oracle host variable?

531


How to create a new user account in oracle?

576


Why does Oracle not permit the use of PCTUSED with indexes?

1947


What privilege is needed for a user to connect to oracle server?

555