Class - 12 CBSE Computer Science — Assertion Reason Type Questions
Assertion. The join, in which columns are compared for equality, is called Equi-join.
Reason. The join queries only produce combined rows from tables having some common column, when compared for equality.
SQL Joins & Grouping
3 Likes
Answer
(c)
Assertion is true but Reason is false.
Explanation
The join, in which columns are compared for equality, is called Equi-join. Join queries in SQL can produce combined rows based on various conditions, not just equality comparisons. For example, join conditions can involve inequality comparisons (<, >, <=, >=), as well as other logical operators and functions.
Answered By
3 Likes