Which SQL statement queries data from a table?

• A. Update
• B. Select
• C. Text
• D. Add

Answer: (B)

Querying data from a table is done with the SELECT statement. SELECT asks the database to fetch specific columns (or all columns with *) from a table, and you can refine which rows to return with clauses like FROM, WHERE, and ORDER BY. For example, SELECT * FROM employees returns every column for every row in the employees table. The other options perform different actions: one modifies existing rows, another is used for adding new rows, and a non-SQL term isn’t a valid command. So the statement that retrieves data from a table is the SELECT statement.