A subquery is a query within a query. A join is used to combine rows from

what is the main difference between join and subqurey?

Question Posted / ankush

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

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Which certification is best for sql?

990

What do we need to check in database testing?

1018

What is sharding in sql?

987

Is oracle and sql same?

1013

What trigger means?

986

Explain ddl statements in pl/sql?

1010

Define implicit and explicit cursors.

1145

How do you update a value in sql?

1043

What are the topics in pl sql?

972

What is the meaning of disabling a trigger?

1182

what are set operators in sql? : Sql dba

1054

What are variables in pl sql?

1167

What is rename command in sql?

1036

What is the sql case statement?

1008

What is sql profiler in oracle?

1094