Question

In an SQL query, which SQL keyword is used to state the condition that specifies which rows are to be selected?

a) EXISTS
b) FROM
c) SELECT
d) SET
e) WHERE

Answer 1

The SQL keyword used to specify the condition for selecting rows is the WHERE clause, which filters records based on a given condition.

Step-by-step explanation:

In an SQL query, the keyword used to state the condition that specifies which rows are to be selected is e) WHERE. The WHERE clause filters records and fetches only those rows that satisfy a specified condition. For instance, in a query like SELECT FROM Customers WHERE Country='Mexico the WHERE clause limits the result set to only those rows from the Customers table where the Country column has the value 'Mexico'.