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
- 16813 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 a live lock? : Sql server database administration
How data can be copied from one table to another table?
Why should you use or avoid select * statements?
Explain why variables called the most powerful component of ssis?
What is partitioned view?
What is rolap and its advantage? : sql server analysis services, ssas
How to filter records of table in SQL SERVER?
What is key set driven?
Explain various On-Delete options in a DB table. Which is the default option?
What is the difference between writing data to mirrored drives versus raid5 drives
What is table valued function and scalar valued functions?
What is primary key, unique key, and foreign key?
What is the fastest way to permanently delete a 1 million row table named customers?
If a stored procedure is taking a table data type, how it looks?
What to check if a User database is locked?
