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
Explain external key management in sql server 2008
What is the default server name for sql server?
what are the three command line utilities and what are their primary functions?
What do you need to connect php to sql server?
Tell me what do you understand by a view? What does the with check option clause for a view do?
How do you trace the traffic hitting a sql server?
Explain how many types of relationship?
What is the difference between mysql and sql server?
Write the syntax for stuff function in an sql server?
What happens if date-only values are provided as date and time literals?
How to delete duplicate rows from table except one?
How much is a sql server license?
What are horizontal and vertical scaling?
What is public role in sql server?
Explain some stored procedure creating best practices or guidelines?