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
Can we update data in a view?
how you can get the list of largest tables in a database? : Sql server administration
Do you know what is difference between index seek vs. Index scan?
What is a synonym for manipulation?
How to transfer an existing table from one schema to another schema in ms sql server?
What are filegroups in sql server?
What is the importance of three tier architecture?
When is the use of update_statistics command?
1 01 101 01010
Is candidate a key?
What are the types of subquery?
What are the properties of the transactions?
Explain how to use linked server?
What are user defined functions in ms sql server?
What are the steps you will take to improve the performance of a poor performing query?