What is subquery ?
- 6 Answers
- 10765 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / xx
A query embedded inside another (parent) SQL statement,
returning rows used by the parent.
| Is This Answer Correct ? | 15 Yes | 6 No |
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 |
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 |
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 |
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 |
In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
Is db2 a mainframe?
What is cursor stability in db2?
What is database manager in db2?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
how can i pull up a query which was previously stored in qmf
wht displays the number of times a query modified ?
What is a db2 cursor?
how to check the table is empty or not?
What are the three types of page locks that can be held?
what is diffrence b/w file-aid tool and file-aid utility???
COBOL 
