The `SELECT` statement is the bread and butter of the SQL developer. Select returns the desired records in the format of a table which is specified with a `FROM` statement. ```SQL SELECT <col1>, <col2> FROM <table>; ``` While `*` can be used to select all columns from a table, in production the columns should be specified explicitly. The select statement can include these operators (in this order) - [[join]] - [[where]] - [[group by]] - [[having]] - [[order by]] Select statements can also support [[functions and expressions]]. Advanced queries might also use - [[subquery]] - [[union]] - [[case]] - [[offset]]