# SELECT in T-SQL

SELECT in T-SQL: SELECT in T-SQL: an overview, SELECT Query Structure, Simple SELECT Query, Specifying Columns, Calculations in Columns, TOP and ORDER BY.

Updated: November 3, 2026

1. [SELECT in T-SQL: an overview](https://www.ask-codey.com/lessons/select-in-t-sql-an-overview) (Novice): A SELECT statement asks the database a question and gets back a table of answers; T-SQL is SQL Server's version of SQL.
2. [SELECT Query Structure](https://www.ask-codey.com/lessons/select-in-t-sql-select-query-structure) (Novice): A SELECT statement is built from clauses that always appear in the same order; this chapter uses SELECT, FROM, WHERE and ORDER BY.
3. [Simple SELECT Query](https://www.ask-codey.com/lessons/select-in-t-sql-simple-select-query) (Novice): SELECT \* FROM a table returns every column and every row, the quickest way to see what a table holds.
4. [Specifying Columns](https://www.ask-codey.com/lessons/select-in-t-sql-specifying-columns) (Novice): List the columns you want, in the order you want them, and rename them in the result with AS.
5. [Calculations in Columns](https://www.ask-codey.com/lessons/select-in-t-sql-calculations-in-columns) (Apprentice): Work out new values as you query, with arithmetic on a row's columns and joined text, and give each calculated column a name.
6. [TOP and ORDER BY](https://www.ask-codey.com/lessons/select-in-t-sql-top-and-order-by) (Novice): Sort a query's results with ORDER BY, ascending or descending, by one column or several, and keep only the first rows with TOP.

Source: https://www.ask-codey.com/courses/csharp-full-stack-bootcamp/topics/select-in-t-sql