Code has been added to clipboard!

SQL SELECT and SELECT ALL Statements

Reading time 1 min
Published Jan 4, 2016
Updated Oct 9, 2019

TL;DR – The SQL SELECT command is commonly used for search queries. Using it, you can select specific data from your SQL databases. The data you select is stored in a table called a result-set.

Syntax of SQL SELECT

Selecting specific columns

Example
SELECT column1, column2, ...
FROM table_name;

Selecting all columns

Example
SELECT * FROM table_name;
Theory is great, but we recommend digging deeper!

Examples using a demo database

The Users table

ID Username Email Password
1 alfredfutter [email protected] secret1
2 atrujillo [email protected] secret2
3 moreno.antonio [email protected] secret3
4 hardythomas [email protected] secret4
5 bergluns [email protected] secret5

Using SELECT to retrieve data of specific columns

Example
SELECT username,email 
FROM users;

Using SELECT to retrieve data of all columns

Example
SELECT * FROM users;

Note: SELECT * selects all columns, SELECT ALL selects all rows.