Interested to Buy Any Domain ? << Click Here >> for more details...
What is subquery ?
- 6 Answers
- 12666 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 |
Where can you declare a cursor in a cobol-db2 program?
What is db2 bind process?
Define db2 and its databases?
Is schema the same as database?
What is dbrm in db2 database?
What are the uses of db2 optimizer?
What is reorg in database?
What is the use of db2?
How can we define a table? How can we apply SEARCH ALL on it ?
what are the bind parameters?
What is the syntax for creating a table in the db2 database?
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
COBOL 
