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

Answers were Sorted based on User's Feedback



Whatz the main diff between Subquery and a Join..

Answer / 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

Whatz the main diff between Subquery and a Join..

Answer / ramakrishna alla

Above one is exact answer that says sub query is used to get data based on unknown condition (example: select the employee's salary where employee salary greater than clerk) here first we find out clerk salary and then based on his salary we find employee's salary according to above query)
join is used to get the data from atleast 2 tables.

Is This Answer Correct ?    0 Yes 0 No

Whatz the main diff between Subquery and a Join..

Answer / gomolemo kasale

a sub query is a query nested within another query while
join select rows from multiple table

Is This Answer Correct ?    0 Yes 0 No

Whatz the main diff between Subquery and a Join..

Answer / suryakiran

The main usage of subqueries is to retrieve a single record
from that same table or another table.

And also we can use subqueries to retrieve multiple
records,for this we have to use multiple sub queies,instead
of this its better to use joins based on a condition.

We can perform all operations for joins by using subqueries
but it is very complicated.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle General Interview Questions

Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?

6 Answers   IBM,


how to hide the stored procedure inside a package

1 Answers  


write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c

1 Answers   KPIT,


How to use null as conditions in oracle?

0 Answers  


What is Parallel Server ?

3 Answers  


Why do we need oracle client?

0 Answers  


How to view the dropped tables in your recycle bin?

1 Answers  


What is meant by recursive hints ?

1 Answers  


is database gud carrier option??

1 Answers  


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

0 Answers  


How to connect to the server with user account: sys?

0 Answers  


Explain the use of parfile option in exp command.

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1803)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)