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
How do I find the sql server instance name?
What method is used by the Command classes to execute SQL statements that return single values?
what are the important architecture components of SSRS?
How do you handle datasets larger than 50 gb?
What are parameterized reports?
What is sql server english query?
Explain user defined views?
Why union all is faster than union?
Why use stored procedures in sql server?
Why functions are used in sql server?
How you trouble shoot when any job fails
What is awe?
Explain the Ways to improve the performance of a sql azure database?
Mention the uses of stored procedures.
Explain nested trigger in sql?