Question

The purpose of WHERE clause in a SQL statement is to ______.

Options

• Create a table.

• Filter rows based on a specific condition.

• Specify the columns to be displayed.

• Sort the result based on a column. 

Answer 1

The purpose of WHERE clause in a SQL statement is to filter rows based on a specific condition.

Explanation:

1. To filter rows in a query according to a particular condition, utilize SQL's WHERE clause. 
2. It enables you to retrieve only the rows that satisfy the given requirements.