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 is the difference detween pairwise comparison subquary
and non pairwise comparison subquary?

Answer Posted / taroon

See the thing is in pairwise comparison, we are taking the
columns which are of composite key type, so that the
comparisons will be very effective. But nonpairwise
comparisons are like multi_row subqueries with IN operator,
where we are checking single column values.

But the results will be different in both the cases. Just
try. If you want some examples regarding that, just do let
me know.

Is This Answer Correct ?    2 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to determine the service pack currently installed on sql server? : Sql server database administration

945


sql database suspect We have a sql database that is showing as suspect. How can we recover?

1907


What is unpivot?

998


What is normalization of database?

1082


Is mysql the same as sql server?

958


What is logshipping and its purpose?

973


How to make a column nullable?

1092


Explain syntax for dropping triggers?

915


What is primary key and example?

929


How can you find out which stored procedures are recompiling?

908


What does Master database contains?

1112


What the different components in replication and what is their use?

936


How to change a login name in ms sql server?

1064


what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

1025


How to override dml statements with triggers?

1153