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

What do you think about pl/sql?

0 Answers  

What is the use of partition by in sql?

0 Answers  

Why is theta join required?

0 Answers  

what is a constraint? Tell me about its various levels. : Sql dba

0 Answers  

Can a key be both primary and foreign?

0 Answers  




i have a word ***********hello********world******. I require a o/p **********hello world**********, Need to delete the middle stars.

3 Answers  

How many triggers can be implemented for a table?

3 Answers   HSBC,

what is view? : Sql dba

0 Answers  

how i do the database testing of online money transactions between two parties (client and organization). suppose our company makes a website for our client and give a extra feature of online money transaction with there clients then how i test this feature in database testing

1 Answers  

Can ddl statements be used in pl/sql?

0 Answers  

Can we group by two columns in sql?

0 Answers  

what are tables and fields? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories