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
Tell me what are cursors and when they are useful?
What type of Index will get created after executing the above statement?
Is the order of columns in the set clause important in ms sql server?
Explain trigger classes i.e. Instead of and after trigger?
How to use clusters?
What is data block and how to define data block size?
How do I start sql server 2016?
What are the types of containers in ssis?
How would you go about developing a ssrs report?
How many instances per computer are there in sql server 2000?
What is the command dbcc checkdb used for?
What is query processing?
What are the properties and different types of sub-queries?
Explain what is sql server english query?
How to skip remaining statements in a loop block using continue statements?