Which SQL clause is used to retrieve specific rows from a table?
2025
Which SQL clause is used to retrieve specific rows from a table?
- A.
SEARCH
- B.
FETCH
- C.
SELECT
- D.
FIND
Attempted by 1352 students.
Show answer & explanation
Correct answer: C
To retrieve specific rows from a table in SQL, the appropriate clause is used to filter and select data. The SELECT clause is used to specify which columns and rows to retrieve. It can be combined with a WHERE clause to filter rows based on conditions. Other options like SEARCH, FETCH, and FIND are not valid SQL clauses for this purpose.