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 is null value in db2?
How would the varchar column remarks defined?
What is buffer pool in the db2 database?
How to get the ddl of a table in db2?
What is a storage group (stogroup)?
How is a typical db2 batch pgm executed?
How to execute stored procedure in db2 command editor?
What is a collection in db2?
What is a bind in db2?
What does db2 blu stand for?
What is query_cache_limit?
Can there be more than one cursor open for any program?
How many databases can be created inside an instance in db2 ?
What is database reorganization?
List some fields from sqlca?