SELECT

Retrieves rows from tables or views. Supports filtering, sorting, aggregation, joins, and subqueries.

Syntax

postgresql

SELECT columns FROM table WHERE condition ORDER BY col LIMIT n;

Example

postgresql

SELECT u.name, u.email, COUNT(o.id) AS orders
FROM users u
LEFT JOIN orders o ON o.user_id = u.id
WHERE u.active = true
GROUP BY u.id
HAVING COUNT(o.id) > 0
ORDER BY orders DESC
LIMIT 20;