Which SQL clause is used to restrict the rows returned by a query in Oracle?
2023
Which SQL clause is used to restrict the rows returned by a query in Oracle?
- A.
WHERE
- B.
GROUP BY
- C.
HAVING
- D.
ORDER BY
Attempted by 160 students.
Show answer & explanation
Correct answer: A
The correct answer is Option A: WHERE. In Oracle and standard SQL, the WHERE clause is used to filter and restrict individual rows from a table based on a specified condition before any grouping occurs. Only rows that satisfy the WHERE condition are returned in the final result set.