Interested to Buy Any Domain ? << Click Here >> for more details...
What is subquery ?
- 6 Answers
- 12653 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 |
How are write I/Os from the buffer pool executed?
Can I use LOCK TABLE on a view?
How to resolve -917 sql code in DB2?
How do you retrieve the data from a nullable column?
what is + sign and -ve sign for sql code ?
What is a collection?
if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records
how 2 resolve the -311 sqlcode
How can you do the explain of a dynamic sql statement?
What is dpf in db2?
when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations
What is reorg in DB2
COBOL 
