Vidyalelo
Database · Q3

Introduction to SQL

Programming · Database · question 3

Q3

The SQL WHERE clause:

A.
limits the column data that are returned.
B.
limits the row data are returned.
Answer
C.
Both A and B are correct.
D.
Neither A nor B are correct.

Answer: Option B

Solution

Answer: Option B
Solution:
The SQL WHERE clause is used to filter records.

It limits the row data that are returned by specifying conditions that the records must meet.

Option A is incorrect because the WHERE clause does not limit column data; this is done by the SELECT statement.

Option C is incorrect because only Option B is correct.

Option D is incorrect because the WHERE clause does limit the row data that are returned.

Conclusion: The WHERE clause in SQL is used to filter rows based on specific conditions, limiting the row data returned.