Difference between sub query and nested query ?
Answer Posted / roopesh kumar
Main Diff. b/w Subquery & Nested Subquery:
The query inside a query is known as a subquery.
When we have another query again query inside subquery then
it is known as nested subquery.
| Is This Answer Correct ? | 25 Yes | 36 No |
Post New Answer View All Answers
What is Reduced List of Values?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
What are the uses of Database Trigger ?
What is the usage of synonyms?
How to write numeric literals in oracle?
What to do if the binary spfile is wrong for the default instance?
How to define a variable of a specific record type?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
How to enter a new row into a table interactively?
What are a cluster and non-cluster index?
Can we create database in oracle using command line ?
What is oracle thin client?
How to estimate disk space needed for an export job?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
How to get the Installed Oracle Version Information ?