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 db2 catalog database?
When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?
What is the picture clause of the null indicator variable?
How can you display the current date & current time ?
How to rename a table in DB2 ?
Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?
how to resolve -811
can i code union in cobol-db2 pgm ?
What does db2 stand for?
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 are the various isolation levels possible?
what's the best lock size that you could use when you create a tablespace?