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 / adil khan

main difference between join and subqurey is that join is
used for known condition while subquery is used for unknown
condition.

Is This Answer Correct ?    6 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to define a record variable to store a table row?

1025


How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2221


What are set operators?

1045


What happens if you set the sga too low in oracle?

1078


What is the fastest query method to fetch data from the table?

1317


How to run create database statement again?

1100


Explain overloading. Can functions be overloaded?

946


Explain the use of rows option in exp command.

1044


How does Oracle guarantee data integrity of data changes?

2354


What is SQL access advisor in Oracle?

1156


What are data pump export and import modes?

1030


20. Using a set operator, display the client number of all clients who have never placed an order.

2156


How to create a table index?

1088


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

965


How to assign query results to variables?

1022