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
Do you know what are acid properties of transaction?
What is update locks?
How will you hide an attribute? : sql server analysis services, ssas
What is difference between views and tables?
Explain alternate key, candidate key and composite key in sql server?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
How can I tell if sql server is 32 or 64 bit?
What is analysis service repository?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
What is 1nf 2nf?
What is the difference between push and pull subscription? : sql server replication
What is mssql?
What is multi-statement table-value user-defined function?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
Does table partitioning improve performance?