What are sub-queries? Give example? In which case
sub-queries are not feasible?
- 4 Answers
- 11004 Views
- Infosys, I also Faced
- E-Mail Answers
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 the order by used for?
What are the properties and different types of sub-queries?
Explain what are various ways to enhance the ssrs report?
What is the difference between seek predicate and predicate?
Tell me what is sql profiler?
How to sort query output in descending order in ms sql server?
Explain what is public role in sql server?
what type of index will get created after executing the above statement? : Sql server database administration
How can you fetch alternate records from a table?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
What is system stored procedures?
List the data types available in mssql?
Define inner join? Explain with an example?
What is the log shipping?
What happens if an integer is too big for int date type?
