what is the main difference between join and subqurey?
- 3 Answers
- 6471 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
How do I edit a stored procedure?
How do you run a query?
Write a sql query to find the names of employees that begin with ‘a’?
What is sp_helptext?
Why do we use partitions in sql?
What is the difference between syntax error and runtime error?
What is the sql*loader? : aql loader
What is foreign key sql?
Where do we use pl sql?
what are tables and fields? : Sql dba
Is pl sql different from sql?
What does the base_object_type column shows in the user.triggers data dictionary view?
Differentiate between sga and pga.
In pl/sql, what is bulk binding, and when/how would it help performance?
Are stored procedures faster than dynamic sql?
