Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What do you mean by SQL injection attack?

1129


What new changes are being made in SQL Server?

1272


Can group functions be used in the order by clause in ms sql server?

1068


What happens when unicode strings concatenate with non-unicode strings?

1187


Tell me about joins in database system and explain each in detail.

1107


How is sql server used?

1015


Explain what are magic tables in sql server?

1047


How to create a store procedure with encryption?

1057


Why do we use trigger?

1029


what are different types of raid configurations? : Sql server database administration

1102


List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

187


What is the purpose of the master database?

1201


How to receive output values from stored procedures?

1236


What are different types of subquery?

1310


Explain Geography datatype in SQL Server

1192