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 |
What is dbrm? What it contains?
Can we use select * statement in cobol program without giving field names ???
What is a db2 tablespace?
How is the SUBSTR keyword used in sql?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is a root page?
Explain packages.
Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is runstats and reorg in db2?
In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?