what is the main difference between join and subqurey?

Question Posted / nallapu.sss@gmail.com

3 Answers
7543 Views
Oracle, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the main difference between join and subqurey?..

Answer / ravi

all join may be sub query , but sub-query never be join

Is This Answer Correct ?

7 Yes

0 No

what is the main difference between join and subqurey?..

Answer / ankush

A subquery is a query within a query.
A join is used to combine rows from multiple tables (2 or
more tables).
Its also can be done within a single table.

Is This Answer Correct ?

7 Yes

1 No

what is the main difference between join and subqurey?..

Answer / udayselva

Subquery returns only one row and Join return More than one rows

Is This Answer Correct ?

0 Yes

6 No

Post New Answer

More SQL PLSQL Interview Questions

What are the types of join in sql?

0 Answers

Which data type is a composite type?

0 Answers

a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution

0 Answers TCS,

What is dcl in sql?

0 Answers

What is the difference between in and between in sql?

0 Answers

how to get a list of all tables in a database? : Sql dba

0 Answers

SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;

10 Answers

what are the t string functions available in tsql? : Transact sql

0 Answers

Is oracle sql free?