Difference between sub query and nested query ?
- 19 Answers
- 64770 Views
- Keane India Ltd, TCS, I also Faced
- E-Mail Answers
Answer Posted / nirvaya
A subquery is a query within a query. In Oracle, you can
create subqueries within your SQL statements. These
subqueries can reside in the WHERE clause, the FROM clause,
or the SELECT clause. Most often, the subquery will be
found in the WHERE clause. These subqueries are also called
nested subqueries.
| Is This Answer Correct ? | 9 Yes | 6 No |
Post New Answer View All Answers
How to delete multiple rows from a table in oracle?
Is oracle an operator?
What is a sub query and what are the different types of subqueries?
What are the types of trigger in oracle?
Difference between pre-select and pre-query
How do we represent comments in oracle?
How can you merge two tables in oracle?
Please explain drop constraint oracle?
Can I create users through internet explorer in oracle 10g?
Explain temporal data types in oracle
What is a user account in oracle?
Explain the importance of .pll extension in oracle?
How to write a query with an inner join in oracle?
What is a database schema in oracle?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
