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

if table named a is there and 4 records are there then how to swap (1 and 3) and (2 and 4) records at a time

1 Answers  

How do you explain an index?

0 Answers  

What are the features of pl sql?

0 Answers  

Why truncate is faster than delete?

0 Answers  

What does t sql mean?

0 Answers  




What is difference between stored procedures and application procedures?

0 Answers  

What is a record in pl/sql?

0 Answers  

What is cursor in pl sql with examples?

0 Answers  

what are the join types in tsql? : Transact sql

0 Answers  

What is the most important ddl statements in sql are?

0 Answers  

What is the difference between SQL Constraint and PL/SQL constraint.Pls give all the constraint name.

3 Answers   TCS,

What is file based approach?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories