Put in order · SQL and MySQL course · Module 1: Introduction to databases

Steps of building a query

Arrange the steps of building a simple data-retrieval query (from first to last):

Items to put in order

  • End the query with a semicolon ;
  • After the SELECT keyword, list the columns you want to see (or *)
  • Name the table after the FROM keyword
Show the answer

Correct order:

  1. After the SELECT keyword, list the columns you want to see (or *)
  2. Name the table after the FROM keyword
  3. End the query with a semicolon ;