What is a subselect? Is it different from a nested select?
Answer / 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 |
What is meant by explain?
Can you access the DB2 Directory table using SQL?
What is difference between alias and synonym in db2?
Mention and explain the contention situations caused by locks?
Can you Average the Characters ?
How is a typical DB2 batch program executed ?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What's The Error Code For Unique Index Voilation?
What are the rules for db2 programming?
What's the Maximum Length of SQLCA and what's the content of SQLCABC?
What is meant by a unit of recovery?
Define data page.