what is the main difference between join and subqurey?

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 is forward declaration in pl sql?

0 Answers  


What are basic techniques of indexing?

0 Answers  


What is the difference between subquery and correlated query?

0 Answers  


Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!?

3 Answers   eBay,


Explain the types of joins in sql?

0 Answers  






Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

0 Answers  


Sql technical questions

0 Answers  


Explain the structure of pl/sql in brief.

0 Answers  


Write the order of precedence for validation of a column in a table ?

2 Answers  


What is a transaction?

5 Answers  


When should I use nosql database?

0 Answers  


What is sql keyword?

0 Answers  


Categories