Interested to Buy Any Domain ? << Click Here >> for more details...
What are sub-queries? Give example? In which case
sub-queries are not feasible?
- 4 Answers
- 11925 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
Explain trigger and trigger types?
Do you know what is blocking?
What is rtm version in sql server?
What are the properties and different types of sub-queries?
What is #temp and @table variable in SQL server?
What is the difference between index seek vs. Index scan?
What is inline variable assignment?
How do clustered indexes store data?
What are scalar functions in sql?
What is data source object?
What are the types of sql server?
Where actually sql azure database is hosted?
Do you know what is user defined datatypes and when you should go for them?
What is full outer join in sql server joins?
Explain left outer join and right outer join?
