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
Write a sql query to sort on different column name according to the parameters passed in the function?
What is temporal table?
Explain triggers?
Explain about builtinadministrator?
What is the cartesian product of table?
What are distributed partitioned views?
How to connect php with different port numbers?
Write an sql query to find first weekday of the month?
How to stop a loop early with break statements in ms sql server?
What is b tree index?
What is an execution plan?
What is replication and database mirroring?
What is filestream?
What's new in sql management studio for sql server? : sql server management studio
Is there any difference between the primary key and unique key?