The SQL WHERE clause:
A. limits the column data that are returned
B. Neither A nor B are correct.
C. Both A and B are correct
D. limits the row data are returned.
Answer: Option D
Solution (By Examveda Team)
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 B is incorrect because the WHERE clause does limit the row data returned.
Option C is incorrect because only Option D is correct.
Conclusion: The WHERE clause in SQL is used to filter rows based on specific conditions, limiting the row data returned.
This Question Belongs to User Ask Question >> Miscellaneous
Join The Discussion