Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

11. Display the client number and name and the client number and name of the person who referred that client.

2340


How many types of table in Oracle?

1128


How different is ms access and oracle?

1042


is there a tool to trace queries, like profiler for sql server?

1142


How to change user password in oracle?

1029


can anyody please send me the dump for Oracle 10g certifications for DBA path?

2122


What happens if the update subquery returns multiple rows?

1117


What is the maximum number of triggers that can be applied to a single table?

1029


What is parameterized cursor in oracle?

1153


How to assign query results to variables?

1053


How can we create the complete backup of data in the oracle.

2161


Is the After report trigger fired if the report execution fails ?

2915


Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2326


Explain what are synonyms used for?

1038


What are the general rules on data consistency?

1009