Difference between sub query and nested query ?

Answer Posted / dinesh sahoo

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 ?    12 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain rename?

554


List out the difference between commit, rollback, and savepoint?

618


How to delete all rows a table in oracle?

622


How view is different from a table?

556


How to get execution path reports on query statements?

564






Explain table?

651


How to see free space of each tablespace?

595


hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

1758


How to shutdown your 10g xe server from command line?

555


Explain what are the uses of rollback segment?

584


what happened to the global index when I truncate the data in one of the partition?

1518


How to rename a column in an existing table?

615


What is the fastest query method to fetch data from the table?

863


Explain mutating triggers.

575


Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

1879