Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 53 of 91

JOINS and SET Operations — Question 4

Back to all questions
4
Question

Question 4

Define an equi-join. What is non-equi-join ?

Answer

The join, in which columns are compared for equality, is called equi-join. The comparison operator used is "=".

A non-equi-join is a query that specifies some relationship other than equality between the columns. The comparison operators used are '<>', '<', '>', '<=', and '>='.