What are sub-queries? Give example? In which case sub-queries are not feasible?

What are sub-queries? Give example? In which case
sub-queries are not feasible?

Question Posted / guest

4 Answers
10280 Views
Infosys, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What are sub-queries? Give example? In which case sub-queries are not feasible?..

Answer / bernatshaw

Sub-query means a Query within a Query.
This is the Example:
Select Employee_Id, Employee_name From Employees Where
Employee_Id IN (Select Mgr_Id from Manager)

Is This Answer Correct ?

12 Yes

2 No

What are sub-queries? Give example? In which case sub-queries are not feasible?..

Answer / rajendra

Sub query mean query within query ,but when you use sub
query on larg amount data that time it is not feasible

Is This Answer Correct ?

4 Yes

3 No

What are sub-queries? Give example? In which case sub-queries are not feasible?..

Answer / akhil

text and image datatypes are not allowed in
subqueries.Subqueries cannot manipulate their results
internally, that is, a subquery cannot include the order by
clause, the compute clause, or the into keyword.
Correlated (repeating) subqueries are not allowed in the
select clause of an updatable cursor defined by declare cursor.

Is This Answer Correct ?

1 Yes

2 No

What are sub-queries? Give example? In which case sub-queries are not feasible?..

Answer / amit kumar

A subquery is simply a SELECT query within a SELECT query.

example:-

SELECT City, Salary, (SELECT AVG(Salary) FROM Employee)
AS AvgSalary FROM Employee;

Is This Answer Correct ?

1 Yes

4 No

Post New Answer