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!

Microsoft SQL server 2019

Taurius Litvinavicius

5.0 (0)

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.