what is the difference detween pairwise comparison subquary
and non pairwise comparison subquary?
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 query and its types?
How do I schedule a sql server profiler trace?
What is the difference between a unique key and primary key?
How to find out the list schema name and table name for the database?
What is a scheduled job or what is a scheduled task?
How to delete a database in ms sql server?
Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
Give a example to search fr a string in all stored procedure in sql server.
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
How to convert numeric expression data types using the cast() function?
What is truncate table?
Where can you find the error log information? : sql server database administration
Difference between connected and disconnected database in .net with sql server?
What is the default order of an order by clause?