What is a subselect? Is it different from a nested select?
- 1 Answers
- 7176 Views
- I also Faced
- E-Mail Answers
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 |
DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?
Which component is responsible for processing sql statements and selecting access paths?
how can u understand the end of the table ?
I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?
What is dbrm in db2 database?
Which transaction use a command thread ?
What is the role of union all and union
Is db2 free?
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
What is check constraint in db2?
What is correlation names?
Plan has the optimized access path in it. But is that optimized access path is attained or known
COBOL 
