Which SQL keyword retrieves all columns from a table?

SQL Data Analyst Easy

SQL Data Analyst — Easy

Which SQL keyword retrieves all columns from a table?

Key points

  • SELECT * retrieves all columns from a table.
  • SELECT ALL is not a valid SQL keyword for this purpose.
  • GET COLUMNS and FETCH ALL are not standard SQL keywords for retrieving all columns.

Ready to go further?

Start full exam Practice more questions

Related questions