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


Please Help Members By Posting Answers For Below Questions

What is the maximum number of columns in a db2 table?

1009


How do you select a row using indexes in db2?

862


What is a trigger in the db2 database?

827


List out the three types of page locks that can be held.

921


Can we insert update delete in view?

766


What is meant by dclgen?

870


What is isolation level in db2?

780


How do you simulate the explain of an embedded sql statement in spufi/qmf?

855


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.

2532


How will you return the number of records in table?

718


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 ?...

4063


How can you find out the # of rows updated after an update statement?

875


What does a deadlock mean in DB2?

865


In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

862


Define data page.

838