Which SQL clause is used to filter records based on a specified condition?
Options
-
A.
ORDER BY
-
B.
GROUP BY
-
C.
WHERE
-
D.
More than one of the above
-
E.
None of the above
Correct Answer (Detailed Explanation is Below)
C.
WHERE
Detailed Explanation
- WHERE clause filters rows according to a specified condition.
- It can be used with SELECT, UPDATE and DELETE statements.
- Example: SELECT * FROM students WHERE age > 18;
OOps! You are currently offline.