1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

what is the main difference between join and subqurey?

Question Posted / nallapu.sss@gmail.com

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

How do I run sql profiler?

0 Answers  

what are %TYPE and %ROWTYPE? what is the difference?

7 Answers   ICICI, Saama Tech, Sail,

What is an index and types of indexes. How many number of indexes can be used per table ?

12 Answers   Accenture, BirlaSoft, Cognizant, CTS, Symphony,

What is a crud api?

0 Answers  

We have a CURSOR then we need BULK COLLECT?

1 Answers  




Is truncate ddl or dml?

0 Answers  

How to avoid using cursors?

0 Answers  

How do I add a primary key to a table?

0 Answers  

What is the difference between left join and left outer join?

1 Answers  

Which one is better sql or oracle?

0 Answers  

What is a native sql query?

0 Answers  

Is vs as in pl sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories