what is the difference detween pairwise comparison subquary
and non pairwise comparison subquary?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Explain timestamp datatype?
How can you check the level of fragmentation on a table?
How to get a list of columns in a view using the "sp_columns" stored procedure?
What is compound operators?
Can group by be used without aggregate functions?
What is key attribute?
Can we rollback records deleted by a truncate statement?
3 Answers CarrizalSoft Technologies, United Healthcare,
What do we need queues in sql service broker?
What is use of @@ spid in sql server?
What are the different types of indexes?
How to edit table in sql server 2017?
What is a field in a table?