The SELECT Statement
1 min read
SELECT
SELECT retrieves rows from one or more tables.
-- all columns
SELECT * FROM products;
-- specific columns
SELECT name, price FROM products;
Limiting results
SELECT name FROM products LIMIT 10;
LIMIT is great for pagination and previews.