What is a Non-Equi Join?

1.	What is a Non-Equi Join?
Answer» A Non-Equi join entails pulling data from multiple tables by using an INNER join. This type of join matches the columns of two tables based on an inequality using operators such as <, <=, >, >=, !=, BETWEEN, etc. Syntax: SELECT * FROM TableName1, TableName2 WHERE TableName1.columnName [> \| < \| >= \| <= \| != \| BETWEEN ] TableName2.columnName;

Answer»

A Non-Equi join entails pulling data from multiple tables by using an INNER join. This type of join matches the columns of two tables based on an inequality using operators such as <, <=, >, >=, !=, BETWEEN, etc.

Syntax:

SELECT * FROM TableName1, TableName2
WHERE TableName1.columnName [> | < | >= | <= | != | BETWEEN ] TableName2.columnName;

Discussion

No Comment Found

Related InterviewSolutions

State difference between Cross join and Natural Join.
Distinguish between nested subquery, correlated subquery, and join operation.
Explain CTE (Common Table Expression) SQL.
State difference between Full Join and Cross Join.
Is it required that the Join condition be based on equality?
What makes a Union clause different from a Join clause?
What is a Non-Equi Join?
What is an Equi Join?
Explain natural join.
How should data be structured to support Join Operations in a many-to-many relationship?

What is a Non-Equi Join?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment