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