Question · SQL and MySQL course · Module 2: Querying data (SELECT)

Column order in the result

What determines the order of columns in the answer to the query "SELECT cena, tytul FROM ksiazki;"?

Answer options

  • The alphabetical order of the column names
  • The order of columns in the table definition
  • The order in which the columns are listed in SELECT
  • Randomly, different each time
Show the answer

Correct answer:

  • The order in which the columns are listed in SELECT