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 are the benefits of using the db2 database?
What is database reorganization?
How to take backup of table in db2?
What is rebind in db2?
What is the role of union all and union
On which levels locks can be applied?
How many databases are there?
What is cobol db2?
What is the connection string to connect to the DB2 Database ?
What is dbrm? When it will be created?
What is the difference between dbm cfg and db cfg file in db2 ?
How do I change the column size in db2?
What is the use of dclgen in db2?
How do I delete a table in db2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.