SQL SELECT and SELECT ALL Statements

Syntax of SQL SELECT

Selecting specific columns

SELECT column1, column2, ...
FROM table_name;

Selecting all columns

SELECT * FROM table_name;

Theory is great, but we recommend digging deeper!

An Interactive SQL Tutorial for Beginners: Introduction to SQL

BitDegree Foundation VSI ©

4.5 (139)

Examples using a demo database

The Users table

Using SELECT to retrieve data of specific columns

SELECT username,email 
FROM users;

Using SELECT to retrieve data of all columns

SELECT * FROM users;

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