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
Explain rename?
List out the difference between commit, rollback, and savepoint?
How to delete all rows a table in oracle?
How view is different from a table?
How to get execution path reports on query statements?
Explain table?
How to see free space of each tablespace?
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.
How to shutdown your 10g xe server from command line?
Explain what are the uses of rollback segment?
what happened to the global index when I truncate the data in one of the partition?
How to rename a column in an existing table?
What is the fastest query method to fetch data from the table?
Explain mutating triggers.
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?