SELECT All Rows

Retrieve all columns and rows from a table

Query

SQL

SELECT * FROM users;

What each clause does

SELECT * retrieves every column from the table. The asterisk (*) is a wildcard. FROM users specifies the source table.

Related tools

SQL Formatter SQL Syntax Cheatsheet

Other SQL examples

SELECT with WHERE INSERT INTO UPDATE SET DELETE FROM INNER JOIN LEFT JOIN GROUP BY ORDER BY Subquery CREATE TABLE Common Table Expression (CTE)Window Function UPSERT (ON CONFLICT)LIMIT & OFFSET