What are sub-queries? Give example? In which case
sub-queries are not feasible?
Answer Posted / 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 |
Post New Answer View All Answers
What do you mean by SQL injection attack?
What new changes are being made in SQL Server?
Can group functions be used in the order by clause in ms sql server?
What happens when unicode strings concatenate with non-unicode strings?
Tell me about joins in database system and explain each in detail.
How is sql server used?
Explain what are magic tables in sql server?
How to create a store procedure with encryption?
Why do we use trigger?
what are different types of raid configurations? : Sql server database administration
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
What is the purpose of the master database?
How to receive output values from stored procedures?
What are different types of subquery?
Explain Geography datatype in SQL Server