nalini

• Mar 22nd, 2005

 

subquery is inner query executes before the the main query.the result of the subquery used in main query

srinivas.T.T

• Jul 20th, 2005

 

Query with in Query is nothing but subquery. Subquery execute only once per table

prathima

• Sep 9th, 2005

 

a subquery is a SELECT statement that is written inside another SQL statement (which is often, but does not have to be, another SELECT). To distinguish the subquery (or inner query) from its enclosing query (or outer query), it must be enclosed within parentheses. Here is an example: 
 
SELECT * FROM clients WHERE clno IN -- outer query 
(SELECT clno FROM firms WHERE city = 'leduc'); -- inner query 
 

annathurai

• Oct 15th, 2005

 

sub-query nothing but Queries within the queries is called the sub -query.example:select empno,empname frome employee where empno=(select empno from empdetails)

Sailaja Pasupuleti

• Dec 3rd, 2005

 

    A sub-query is a part of query.  Sub-queries are useful to find unknown value(s).

   Ex:  To find details of employees who are getting maximum salary.

         In this requirement, the maximum salary not mentioned.

Solution:    

To find maximum salary, 

          select max(sal) from emp;

For that maximum salary the employee details, 

          select * from emp where  sal = (select max(sal) from emp);

So, in the above query, "select max(sal) from emp"  is also a query but it returns a value (unknown or not given) and compares with "sal" column.  This query is called sub-query.

aseemnaithani

 Profile Answers by aseemnaithani Questions by aseemnaithani

• Mar 19th, 2006

 

Please can you tell me the difference between In and Exists predicates in the sun-query

shobana

• Aug 28th, 2006

 

"In" is used to find in a range of values.

Eg: select empno, ename from employee where department in ("SALES","ACCOUNTS","FINANCE","HR");

Records from every department are fetched. Checks department whether in SALES or in ACCOUNTS or in FINANCE or in HR.

Exists just checks for the condition and returns true or false.

Eg: select empno, ename from employee where exists(sal>0);

thumatinagaraju

 Profile Answers by thumatinagaraju Questions by thumatinagaraju

• Oct 24th, 2006

 

simple reply nalini ..goodnagthumati_nagaraju@yahoo.co.in

kshsingh1

 Profile Answers by kshsingh1 

• Jan 22nd, 2007

 

A query nested within another SQL statement is called a subquery.