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

What the AS alias does NOT do

What is NOT true about an alias created with the word AS?

Answer options

  • An alias changes only the label in the query result
  • An alias with a space must be wrapped in quotes
  • The word AS can be dropped, leaving just a space
  • An alias permanently changes the column name in the table
Show the answer

Correct answer:

  • An alias permanently changes the column name in the table