PostgreSQL Advanced SQL Reference: Window Functions, CTEs, JSONB & EXPLAIN ANALYZE
PostgreSQL patterns that separate basic SQL from production-grade queries.
Window functions without GROUP BY collapsing rows
-- Top 3 earners per department:
SELECT * FROM (
SELECT *, ROW_NUMBER() OVER (PARTITION BY department ORDER BY salary DESC)...
releaserun.hashnode.dev2 min read