Question

multiple choice 1 point
to filter rows based on specific conditions in a select statement, which sql clause should be used?
where
order by
pick
group by

Explanation:

The WHERE clause in SQL is specifically designed to filter rows based on specific conditions in a SELECT statement. The ORDER BY clause is used to sort the result - set. PICK is not a valid SQL clause. The GROUP BY clause is used to group rows that have the same values in specified columns.

Answer:

WHERE