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
- 16835 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
Explain use of expression builder.
How to insert data with null values?
How to restore performance issues and how to check?
Why would you use sql agent?
What are translations and its use? : sql server analysis services, ssas
What is a transact-sql statement batch in ms sql server?
What is index fragmentation in ms sql server?
What do you know about system database? : SQL Server Architecture
Suggest a method of joining two tables.
Why use “pivot” in sql server?
What is the difference between lock, block and deadlock? : sql server database administration
How will you decide the active and passive nodes?
What is the purpose of sql profiler in sql server? : sql server database administration
What are the events recorded in a transaction log?
Why can there be only one clustered index and not more than one?
