Skip to content

Glossary: SQL Beyond the Basics

Alias

Also written: aliases, AS

A short name given to a table or column inside a query, such as `orders AS o`. Putting the alias before column names avoids 'ambiguous column name' errors when joined tables share a column name.

Where the book teaches it

Related terms

Self join