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 alias in db2?
What is the function of logging in the db2 database?
How do I change the column size in db2?
What are the rules for db2 programming?
What is db2?
What does reorg do in db2?
can all users have the privilage to use the sql statement select * (dml)?
What is runstats db2?
What is check constraint in db2?
Define sqlca.
What is coalesce in db2?
What are the benefits of using the db2 database?
What does runstats do in db2?
What is the physical storage length of timestamp data type?
Can you use max on a char column?