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
- 16843 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 optimization and its types?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
Describe how to use linked server?
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?
What is the distinction amongst delete and truncate?
What is ms sql server index?
How do I manually uninstall an instance of sql server 2016?
Explain stored procedure?
Difference between Logical Page and Physical Page in SSRS.
Issues related in upgrading SQL Server 2000 to 2005 / 2008
After creating the cube, if we added a new column to the oltp table then how you add this new attribute to the cube? : sql server analysis services, ssas
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
How to find the source of a table in sql server?
Do you know the cursor types?
Define self join?
