What is a subselect? Is it different from a nested select?
Answer Posted / 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 |
Post New Answer View All Answers
What is the maximum number of columns in a db2 table?
How do you select a row using indexes in db2?
What is a trigger in the db2 database?
List out the three types of page locks that can be held.
Can we insert update delete in view?
What is meant by dclgen?
What is isolation level in db2?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
How will you return the number of records in table?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
How can you find out the # of rows updated after an update statement?
What does a deadlock mean in DB2?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
Define data page.