Interested to Buy Any Domain ? << Click Here >> for more details...
What is subquery ?
- 6 Answers
- 12380 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 |
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
What are the various data types available in db2?
What is isolation level?
What is a subselect? Is it different from a nested select?
How connect db2 database to datastage?
What is a correlated sub query?
Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..
What is QUIESCE?
What is cursor with hold option in db2?
What is innodb buffer pool?
What do you mean by rollback?
What is an intent lock?
COBOL 
