Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference detween pairwise comparison subquary
and non pairwise comparison subquary?
- 2 Answers
- 16650 Views
- I also Faced
- E-Mail Answers
Answer Posted / parnita
In pair wise comparison we write like this:"where (MGR_ID,
DEPT_ID) IN (SUBQUERY)"IN non pair wise comparison we write
like this:"where (MGR_ID) IN (SUBQUERY)and (DEPT_ID) IN
(SUBQUERY)"In first one we are checking two columns
simultaneously ...
| Is This Answer Correct ? | 20 Yes | 3 No |
Post New Answer View All Answers
Can we use having clause without group by?
How to create function without parameter in sql server?
What is the purpose of update statistics and scope_identity() function?
Why we use the openxml clause?
What is relationship? What number of sorts of relationship are there?
What is buffer cash and log cache in sql server?
What is the difference between implicit and explicit transaction?
what is a mixed extent? : Sql server administration
How will you hide an attribute? : sql server analysis services, ssas
What is a transact-sql statement batch in ms sql server?
How can sql server instances be hidden?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
How to create a user name in a database?
What is join query?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
