What is a subselect? Is it different from a nested select?
Answer / s
Subselect is a SELECT in the WHERE clause, providing values
to the outer select to get the qualifying rows. You can use
up to 225 subselects in a single SQL which are called
nested selects or nested subselects.
| Is This Answer Correct ? | 6 Yes | 0 No |
Explain the function of data manager.
Is db2 a programming language?
How do I delete a table in database?
Which component is responsible for processing sql statements and selecting access paths?
What is the difference between group by and order by?
What is the result of open cursor statement?
What are the contents of dclgen?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What action db2 takes when a program aborts in the middle of a transaction?
Can we insert update delete in view?
How to handle null values in db2
What is a clustering index?