what is the difference detween pairwise comparison subquary
and non pairwise comparison subquary?
- 2 Answers
- 16138 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
Characterize join and name diverse sorts of joins?
What is transaction server auto commit?
What do you mean by an execution plan? Why is it used?
What is advantage data architect?
How can sql server instances be hidden?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
What are subqueries in sql server? Explain its properties.
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
What is SQL Azure Federations?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
How do I connect to sql server database?
What stored by the model?
Benefits of Stored Procedures?
Explain the rules for designing files and file groups in sql server?
Why variables called the most powerful component of ssis?
