Answer / s

Subquery is a SELECT statement used within a WHERE clause
or having CLAUSE of an SQL statment.

Answer / xx

A query embedded inside another (parent) SQL statement,
returning rows used by the parent.

Answer / v.chellappa

Usally subquery is executed first then result return to the
main query.
Based on the returned value the main querey is executed

Answer / kinjal patel

subquery is a slect statement that is embaded in clause of
another sql statement ,called the parent statement.

Answer / pooja intwala

A subquery is a SELECT statement within another SQL statement. The SQL statement can be SELECT, WHERE clause, FROM clause, JOIN, INSERT, UPDATE, DELETE, SET, DO, or another subquery.

Answer / navdeep gill

subquery can be define sa a select query that erturns
single or multiple values

How to fetch the last row from the table in SQL (db2)?

0 Answers  

what is the process of precompiler?

2 Answers  

What is a PLAN table? How will you use it? Give the various fields of PLAN table?

1 Answers   Accenture,

When is the authorization check on DB2 objects done - at BIND time or run time?

1 Answers  

What is a buffer pool?

2 Answers  

What is a view? Why use it?

3 Answers  

What is the difference between a package and a plan?

6 Answers   Infosys, L&T, Mphasis,

How is the SUBSTR keyword used in sql?

1 Answers  

For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

3 Answers  

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

0 Answers  

What are db2 objects?

0 Answers  

what is cursor stability?

2 Answers   IBM,