Difference between sub query and nested query ?

Answer Posted / mohammed al-fahed

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, which resinde in the WHERE
clause.

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is dynamic proxy?

782


What do you mean by a tablespace?

793


What exactly do quotation marks around the table name do?

731


how to do daily transactions with out sql* loader control file regesterd in apps?

1451


What are the benefits of ordbms?

833


How to Truncate Table in Oracle

898


How to bring a tablespace online?

752


Give the different types of rollback segments.

806


How to call a stored function with parameters?

765


What is a table index in oracle?

860


What happens to the indexes if a table is recovered?

779


how the indexes are stored in the Oracle Database?

1977


What is the usage of merge statement?

902


HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2004


State and explain the different types of data models?

733