SELECT
Retrieves data from one or more tables.
Syntax
sql
SELECT column1, column2 FROM table WHERE condition ORDER BY column LIMIT n;Example
sql
SELECT name, email, created_at
FROM users
WHERE active = true
ORDER BY created_at DESC
LIMIT 20;Retrieves data from one or more tables.
SELECT column1, column2 FROM table WHERE condition ORDER BY column LIMIT n;SELECT name, email, created_at
FROM users
WHERE active = true
ORDER BY created_at DESC
LIMIT 20;