# The SELECT Statement

The SELECT Statement: The SELECT Statement: an overview, SELECT query Structure, Simple SELECT Query, Specifying Columns, Calculations in Columns.

Updated: November 16, 2026

1. [The SELECT Statement: an overview](https://www.ask-codey.com/lessons/the-select-statement-an-overview) (Novice): A SELECT statement, or query, asks the database a question and returns the rows and columns that answer it.
2. [SELECT query Structure](https://www.ask-codey.com/lessons/the-select-statement-select-query-structure) (Novice): A SELECT query is built from keywords that must appear in a fixed order: SELECT, FROM, JOIN, WHERE, GROUP BY, HAVING, ORDER BY and LIMIT.
3. [Simple SELECT Query](https://www.ask-codey.com/lessons/the-select-statement-simple-select-query) (Novice): Use SELECT \* FROM to return every column and every row of a table or view.
4. [Specifying Columns](https://www.ask-codey.com/lessons/the-select-statement-specifying-columns) (Novice): List the columns you want after SELECT, in the order you want them, instead of using \*.
5. [Calculations in Columns](https://www.ask-codey.com/lessons/the-select-statement-calculations-in-columns) (Apprentice): Calculate a new column from other columns in the same row, such as sales_price \* quantity.

Source: https://www.ask-codey.com/courses/java-full-stack-bootcamp/topics/the-select-statement
