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 the maximum number of tables that can be joined ?
Which catalog tables contain authorization information?
Is db2 relational database?
What are the Isolation levels possible ?
What do the initials DDL and DML stand for and what is their meaning?
What is the default page size of buffer pools?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
When do you specify the isolation level? How?
how can we retrieve the 100 records of the file ?
What is ibm db2 used for?
what needs to be done if a table is in copy pending / check pending status?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?