Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- ROW_NUMBER — unique rank within each partition SELECT id, user_id, total, created_at, ROW_NUMBER() OVER (PARTITION BY user_id ORDER BY created_at) AS order_seq FROM orders; -- RANK vs DENSE_RANK (handle ties differently) SELECT name, score, RANK() OVER (ORDER BY score DESC) AS rank_with_gaps, DENSE_RANK() OVER (ORDER BY score DESC) AS rank_no_gaps FROM leaderboard; -- Running total with SUM window function SELECT created_at::DATE AS order_date, total, SUM(total) OVER (ORDER BY created_at ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW ) AS running_total FROM orders ORDER BY created_at; -- LAG/LEAD — compare with previous/next row SELECT month, revenue, LAG(revenue) OVER (ORDER BY month) AS prev_month, revenue - LAG(revenue) OVER (ORDER BY month) AS month_over_month FROM monthly_revenue; -- NTILE — divide rows into 4 quartiles SELECT name, score, NTILE(4) OVER (ORDER BY score DESC) AS quartile FROM students;
Result
Open