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
- 16945 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
What is sub query and its properties?
Can you insert NULL in unique column?
What is "scheduled jobs" or "scheduled tasks"?
What are different types of join?
Explain about unique identifier data type in sql server?
How is table type constraint applied to a table?
Explain security with sql azure?
Does a server store data?
What is the difference between insensitive and scroll cursor?
what is nonclustered index
What is check constraint in sql server?
Why we need to use secondry database file? though, we can do same work using primary database file also.
What are the disadvantages of indexes?
How do I find sql server instance name?
How to delete a login name in ms sql server?
