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

Write a sql query to sort on different column name according to the parameters passed in the function?

904


What is temporal table?

887


Explain triggers?

1005


Explain about builtinadministrator?

1053


What is the cartesian product of table?

1009


What are distributed partitioned views?

1075


How to connect php with different port numbers?

1085


Write an sql query to find first weekday of the month?

916


How to stop a loop early with break statements in ms sql server?

1020


What is b tree index?

915


What is an execution plan?

1148


What is replication and database mirroring?

1047


What is filestream?

1001


What's new in sql management studio for sql server? : sql server management studio

1065


Is there any difference between the primary key and unique key?

999