What is subquery ?

Answers were Sorted based on User's Feedback



What is subquery ?..

Answer / s

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

Is This Answer Correct ?    26 Yes 5 No

What is subquery ?..

Answer / xx

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

Is This Answer Correct ?    15 Yes 6 No

What is subquery ?..

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

Is This Answer Correct ?    7 Yes 1 No

What is subquery ?..

Answer / kinjal patel

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

Is This Answer Correct ?    3 Yes 0 No

What is subquery ?..

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.

Is This Answer Correct ?    0 Yes 0 No

What is subquery ?..

Answer / navdeep gill

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

Is This Answer Correct ?    3 Yes 5 No

Post New Answer

More DB2 Interview Questions

What is dbrm? What it contains?

0 Answers  


Can we use select * statement in cobol program without giving field names ???

3 Answers   Zensar,


What is a db2 tablespace?

0 Answers  


How is the SUBSTR keyword used in sql?

1 Answers  


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

0 Answers   IBM,






What is a root page?

1 Answers  


Explain packages.

0 Answers  


Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

1 Answers   UST,


suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?

5 Answers   IBM,


My sql statement select avg(salary) from emp yields inaccurate results. Why?

0 Answers  


What is runstats and reorg in db2?

0 Answers  


In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?

1 Answers   HCL,


Categories