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?
Answer: C. SELECT — 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…
- A.
SEARCH
- B.
FETCH
- C.
SELECT
- D.
FIND
Attempted by 1812 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.
Loading lesson…