Computer Science
Assertion. SQL SELECT query can also fetch rows from multiple tables.
Reason. A join is a query that combines rows from two or more tables.
SQL Joins & Grouping
1 Like
Answer
(a)
Both Assertion and Reason are true and Reason is the correct explanation of Assertion.
Explanation
SQL SELECT queries can fetch rows from multiple tables using JOIN operations. This allows retrieving data from related tables simultaneously in a single query. A join in SQL is a query that combines rows from two or more tables based on a specified condition, such as matching values in a common column.
Answered By
2 Likes
Related Questions
Assertion. SQL SELECT's GROUP BY clause is used to divide the result in groups.
Reason. The GROUP BY clause combines all those records that have identical values in a particular field or in group by fields.
Assertion. A GROUP BY query can also include functions.
Reason. ALL SQL functions can be used in a GROUP BY query.
Assertion. Generally, a join query combines rows from multiple tables having some common column(s) and a joining condition, but not always.
Reason. A Cartesian product is an unrestricted join where all possible combinations of rows from multiple tables are created without any condition on them.
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.