Question

In an SQL query, which SQL keyword is used to join two conditions that both must be true for the rows to be selected?

1) AND
2) EXISTS
3) HAVING
4) IN
5) OR

Answer 1

The SQL keyword to join two conditions that must both be true for selection is 'AND'. It is used to narrow search results by including all specified search terms in the database query results.

Step-by-step explanation:

In an SQL query, the SQL keyword used to join two conditions where both must be true for the rows to be selected is AND. This keyword narrows search results to ensure that all specified conditions are met. For instance, if a database query includes the conditions 'customers.age > 18 AND customers.subscription = true', this will yield a result set of customers who are older than 18 and are subscribed. The AND operator acts as a logical conjunction in a way that is analogous to the intersection in a Venn diagram, where only the common elements of the specified sets are included in the results.