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

What is the purpose of the QUIESE Utility?

1 Answers  

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

0 Answers  

How do you do the EXPLAIN of a dynamic SQL statement?

2 Answers  

How to know the primary key of a table without defining the primary key in the table?

5 Answers   Satyam,

If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?

1 Answers   RBS,

How do you eliminate duplicate values in db2?

0 Answers  

What is the use of value function?

0 Answers  

How to check table size in db2 sap?

0 Answers  

What is ACQUIRE/RELEASE in BIND?

3 Answers   Cognizant,

When Can you be sure that a query will return only one row?

4 Answers   IBM,

What is the picture clause of null indicator variable?

0 Answers  

Describe the elements of the SELECT query syntax?

3 Answers