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 buffer pool?
What is universal database?
What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)
My sql statement select avg(salary) from emp yields inaccurate results. Why?
what is a trigger and types of triggers
If I have a view which is a join of two or more tables, can this view be updatable?
How can you get the number of rows impacted by the last executed query?
What os does db2 run on?
how to resolve -805 . how to see dbrm and package not found
What is CHECK PENDING ?
If I have a view which is a join of two or more tables, can this view be updateable?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.