Class - 12 CBSE Computer Science — Assertion Reason Type Questions
Assertion. The join, in which columns are compared for equality, is called an Equi-join.
Reason. In non-equi joins, the columns are compared with non-equality conditional operators.
- Both A and R are true and R is the correct explanation of A.
- Both A and R are true but R is not the correct explanation of A.
- A is true but R is false.
- A is false but R is true.
SQL Joins & Grouping
2 Likes
Answer
Both A and R are true but R is not the correct explanation of A.
Explanation
The join in which columns are compared for equality is called an Equi-join. A non-equi-join involves comparing columns with non-equality conditional operators, such as '<>', '<', '>', '<=', and '>=', to specify relationships other than equality between the columns.
Answered By
1 Like