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

What happens to the current transaction if the session is ended?

1094


nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2199


What are the oracle differences between nvl and coalesce

1145


Explain what are clusters?

1105


What is using clause and give example?

1031


What is the use of file param in imp command?

1162


Who developed oracle & when?

997


Difference between oracle's plus (+) notation and ansi join notation?

1097


How to rename an existing table?

1121


Give syntax for SQL and ORACLE joins.

1092


How to define an explicit cursor in oracle?

1031


How to start an oracle instance?

1016


Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2119


When do you get a .pll extension in oracle? Explain its importance

1035


what is the dual table in oracle?

989