SQL SELECT Statement

What is the SELECT Statement?

The SELECT statement is the most fundamental SQL command. It retrieves data from one or more tables in a database. Every SQL query you write starts with SELECT.

When you run a SELECT statement, the database engine reads the specified columns from the target table and returns them as a result set. You can select all columns using * or pick specific ones by name.

Syntax

SELECT column1, column2, ...
FROM table_name;

To select every column:

SELECT * FROM table_name;

When to Use

Use SELECT whenever you need to read data from the database:

• Viewing all records in a table
• Retrieving specific columns for a report
• Combining with WHERE to filter results
• Using expressions to compute values on the fly

Key Points

1. Column Order — You control the order of columns in the result by listing them in the desired sequence.
2. Expressions — You can use arithmetic, string functions, and other expressions directly in SELECT.
3. Star Selector — SELECT * returns all columns. In production, prefer naming columns explicitly for clarity and performance.
4. Case Insensitivity — SQL keywords like SELECT and FROM are case-insensitive, but the convention is to write them in uppercase.
5. No Side Effects — A SELECT statement never modifies data; it only reads.

Mastering SELECT is the first step to becoming proficient in SQL. Every filter, join, and aggregation builds on top of this command.