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
- 16856 Views
- I also Faced
- E-Mail Answers
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 |
How to add an address record into adventureworkslt?
How reterive duplicate value in SQL?
How we can compare two database data?
What is Check point? Explain in Brief what it will do?
What is row by row processing ?
What is the difference between char and varchar2 datatype in sql?
What types of Joins are possible with Sql Server?
How to provide values to stored procedure parameters in ms sql server?
What are commonly used mssql functions in php?
What is t-sql script to take database offline – take database online.
how to know description of a table in sqlserver 2000
What is stored in the mssqlsystemresource database? : sql server database administration
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
