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

Whatz the main diff between Subquery and a Join

Answer Posted / anbu

their should be a relationship between the tables then only
we can use join conditions....
But the subquery can be used to retrive data from one or
more table if their is no relation between the tables....

Is This Answer Correct ?    17 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to change system global area (sga) in oracle?

1013


What is the quickest way to fetch the data from a table?

1058


master table and child table performances and comparisons in Oracle ?

2138


What is an oracle?

1021


How index is implemented in oracle database?

1007


Explain the use of grant option in imp command.

1030


How to drop an index in oracle?

1076


What is a trigger and what are its types?

1231


What is the Tune Query

2296


What is parameterized cursor in oracle?

1155


what is the use of system.effective.date variable in oracle?

1120


What are the differences between blob and clob in oracle?

1089


Explain about achiever in sql?

1042


In oracle there is column command, how will you explain that?

1058


Explain the difference between a procedure and a function? What do you understand by those terms?

1090