What is the purpose of the WHERE clause in a SQL query?

A. To specify the columns to be retrieved

B. To filter the rows based on a condition

C. To order the result set

D. To perform mathematical operations

Correct Answer is :

B. To filter the rows based on a condition