Which SQL statement retrieves all columns from a table named customers?

• A. SELECT * FROM customers;
• B. SELECT columns FROM customers;
• C. SELECT ALL FROM customers;
• D. GET * FROM customers;

Answer: (A)

To fetch every column from a table, you use the wildcard asterisk in the SELECT clause. The statement SELECT * FROM customers; asks the database to return all columns from the table named customers for all rows. The asterisk stands for all column names, so you don’t have to list them one by one. Other options don’t fit because they either use syntax that isn’t valid SQL (GET * FROM customers) or attempt to specify a column name literally (SELECT columns FROM customers) or misuse ALL in this context. If you only need some columns, you would list them explicitly, like SELECT id, name FROM customers;.