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
What does db2 blu stand for?
What is db2?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
Mention data types used in db2 ?
What is dbrm? What it contains? When it will be created?
Explain in brief how does db2 determine what lock-size to use?
How to fetch the last row from the table in SQL (db2)?
How can you do the explain of a dynamic sql statement?
What is query_cache_limit?
What is package in cobol db2?
How does coalesce work?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
Explain the contents that are a part of dclgen.
What is the function of logging in the db2 database?
What is buffer pool?