What is the Subquery?

Question Posted / guest

4 Answers
7816 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is the Subquery?..

SELECT Statement which is embedded in another class of
SELECT statement is nothing but "Sub-Query".

In this ..Inner query will execute first.based on that
result outer query will execute.

Thank you,
Suresh

Is This Answer Correct ?

6 Yes

0 No

What is the Subquery?..

Answer / anil_abbireddy

Runs first,executed once,returns values to be used by the
MAIN Query

Is This Answer Correct ?

5 Yes

0 No

What is the Subquery?..

Answer / ramesh

A sub query is a query and it is deepened main query on the another query is called as a sub-query.

Is This Answer Correct ?

0 Yes

0 No

What is the Subquery?..

Answer / rashmi

Query inside a query is called sub query. Always to execute successfully the outer query depends on the output of inner query.
it is if 4 types.

>Scalar sub query
>Corelated sub query
>Nested sub query
>Inline view

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More SQL PLSQL Interview Questions

How to execute a stored procedure?

0 Answers

What will you get by the cursor attribute sql%notfound?

0 Answers

What is database migration?

0 Answers

What is sqlca in powerbuilder?

0 Answers

how to check the 3rd max salary from an employee table? One of the queries used is as follows: select sal from emp a where 3=(select count(distinct(sal)) from emp b where a.sal<=b.sal). Here in the sub query "select count(distinct(sal)) from emp b where a.sal<=b.sal" or "select count(distinct(sal)) from emp b where a.sal=b.sal" should reveal the same number of rows is in't it? Can any one here please explain me how is this query working perfectly. However, there is another query to get the 3rd highest of salaries of employees that logic I can understand. Pls find the query below. "select min(salary) from emp where salary in(select distinct top 3 salary from emp order by salary desc)" Please explain me how "select sal from emp a where 3=(select count(distinct(sal)) from emp b where a.sal<=b.sal)" works source:http://www.allinterview.com/showanswers/33264.html. Thanks in advance Regards, Karthik.

4 Answers

Give an example of Full Outer Join?

1 Answers IBM,

how to write utl file pkg in SQL

1 Answers Oracle,

Why query optimization is needed?

0 Answers

what is self join and what is the requirement of self join? : Sql dba

0 Answers

what's the difference between a primary key and a unique key? : Sql dba

0 Answers

what is autonomouse transaction?

3 Answers Oracle,

Can a select statement fire a trigger?

0 Answers

For more SQL PLSQL Interview Questions Click Here