Which SQL statement is used to select specific columns and rows from a table?
2024
Which SQL statement is used to select specific columns and rows from a table?
- A.
CREATE TABLE
- B.
INSERT INTO
- C.
UPDATE
- D.
SELECT
Attempted by 172 students.
Show answer & explanation
Correct answer: D
The SELECT statement is used to retrieve specific columns and rows from a database table. Its basic syntax includes SELECT column_name FROM table_name WHERE condition.