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 |
How can you quickly find out the # of rows updated after an update statement?
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
What does CURRENTDATA option in bind indicate
What is a clustered index?
What is the function of logging in the db2 database?
Explain the EXPLAIN statement?
What is db2 bind?
explain about index with examples
how can you access index
What are the benefits of using the db2 database?
What is db2 isolation?
What is the difference between cursor stability and repeatable read isolation levels?