PL/SQL Non Equi-Join

Oracle PL/SQL Non Equi-Join

Non Equi-Join is the select query that does not contain the equality operator.

Non Equi-Join Example:

Select o.id, o.customer_id, o.amount
From offers o
Where o.amount Between 6000 and 100000

Result:

ID CUSTOMER_ID AMOUNT
2 1 60000.00
3 4 45000.00
4 5 6000.00