What is a subselect? Is it different from a nested select?
- 1 Answers
- 7270 Views
- I also Faced
- E-Mail Answers
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
Which components manage deadlocks in db2?
How many databases can be created inside an instance in db2 ?
Mention the various locks that are available in db2.
Which component is responsible for db2 startup and shutdown?
Is db2 free?
What is null in db2?
What is a storage group (stogroup)?
How to restart a DB2 program?
Explain about rct in db2?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
How do I connect my db2 database to ibm?
can we view the access paths created by dbrm ? how ? thx
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
How do you find the maximum value in a column in db2?
Is db2 relational database?
