Explain the difference between pairwise and non-pairwise comparisons in multiple column sub-queries.

pravintule

 Profile Answers by pravintule Questions by pravintule

• May 28th, 2010

In pairwise comparison the attributes included in where clause predicate are compered in same predicate and only single predicte is evaluated.where as in non-pairwise comparison the attributes are com...

yogesh.raut

 Profile Answers by yogesh.raut Questions by yogesh.raut

• Mar 13th, 2010

Pairwise means we can put two checks at a time using subquery using ' in ' condition.. Non pairwise mean seprately we have to specifiy subquery for both conditons using equality operator.

Answer Question  Select Best Answer

display the second lowest salary from emp table without using min & all

Pendo

• Jul 17th, 2021

SELECT Top (1) Salary FROM Employee ORDER BY Salary

Code
 

satyam singh

• Apr 22nd, 2020

"HAVING" clause is required. It works with "GROUP BY" clause

Answer Question  Select Best Answer

tej

• Apr 23rd, 2012

The Oracle version starting of I. The starting in 1999 with version 6i, 8i and 9i, I signify "Internet" means stands for "Internet" and Oracle added the "I" to the version name to reflect support for ...

pradeep

• Aug 2nd, 2011

Oracle 9i and Oracle 10g....there are more implementation differences. In terms of architecture, 9i is based on Internet technology while 10g is grid computing based one. Many DBA features like Automa...

Answer Question  Select Best Answer