What is subquery ?
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 can you access index
What is bind package and plan in db2?
What do you need to do before you do EXPLAIN ?
i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?
If I have a view which is a join of two or more tables, can this view be updatable?
What is data manager?
How to create backup table in db2?
When do you use the IMAGECOPY?
Are view updateable?
How to get Top 10 Salaries from a Table
How to fetch the last row from the table in SQL (db2)?
What is rct?