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 is resource db in sql server?
What do you mean by acid?
How do you create a data source?
explain what is raid and what are different types of raid configurations? : Sql server database administration
What are pages and extents? : SQL Server Architecture
How to create new table with "create table" statements?
Suggest a method of joining two tables.
How to insert multiple rows with one insert statement in ms sql server?
What is model database in sql server?
Tell me extended events in sql server 2008?
What are the 7 disadvantages to a manual system?
Explain what are the different index configurations a table can have?
What is a recursive stored procedure in sql server?
What is spatial and temporal data?
Explain error and transaction handling in sql server?