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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I find the sql server instance name?

722


What method is used by the Command classes to execute SQL statements that return single values?

781


what are the important architecture components of SSRS?

112


How do you handle datasets larger than 50 gb?

154


What are parameterized reports?

176






What is sql server english query?

745


Explain user defined views?

746


Why union all is faster than union?

679


Why use stored procedures in sql server?

710


Why functions are used in sql server?

669


How you trouble shoot when any job fails

1678


What is awe?

742


Explain the Ways to improve the performance of a sql azure database?

78


Mention the uses of stored procedures.

733


Explain nested trigger in sql?

762