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...

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

Whatz the main diff between Subquery and a Join

Question Posted / a.n.v.v.siva kumar

Answer Posted / a.n.v.v.siva kumar

The main difference between join and sub query is :
join is used to retrieve data from two different tables
where as in sub query we can retreive data from one table
using the result of the where condition on another table.

Is This Answer Correct ?    8 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to display employee records who gets more salary than the average salary in the department?

1008

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

944

What is Redo Log Buffer in Oracle?

1142

How to define a cusotmer as a supplier in ORACLE R12

2183

Explain what are the type of synonyms?

1062

Explain do view contain data?

949

What are the varoius components of physical database structure of oracle database?

952

Explain an exception?

935

Difference between pre-select and pre-query

1044

How many memory layers are in the oracle shared pool?

1111

Explain what are synonyms used for?

988

Explain the use of online redo log files in oracle.

996

How to commit the current transaction in oracle?

1051

Explain the use of record option in exp command.

952

What are joins, explain all types of joins?

2227