What is a subselect? Is it different from a nested select?
Answer Posted / 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 |
Post New Answer View All Answers
is it compulsory commitment control in journal?
What is load replace in db2?
Who uses db2?
What is the advantage in De-normalizing tables in DB2?
What does sqlcabc has?
What r the comman abends in db2, jcl and cobol???????
What is rebind in db2?
What is db2? Explain.
What is bufferpool in db2?
How do I optimize a query in db2?
Highlight all the advantages that are attached to a package.
What kind of database is db2?
What is runstats utility in db2?
What is explain in db2?
Outputs of explain are with matchcols = 0. What does this signify?