Snippet library

Copy-ready, tested snippets for Python, Flask, JavaScript, SQL, HTML, CSS and Bash. Open any of them in the playground.

Show only snippets saved in this browser

2 snippets

sql

Running total

Cumulative revenue per day with SUM() OVER.

SELECT day,
       revenue,
       SUM(revenue) OVER (ORDER BY day) AS running_total
FROM (
    SELECT created_at::date AS day, SUM(total) AS revenue

intermediate #window-functions#reports

sql

Top N per group

The 3 best-selling products in every category with ROW_NUMBER().

SELECT category, product, revenue
FROM (
    SELECT c.name AS category,
           p.name AS product,
           SUM(oi.quantity * oi.unit_price) AS revenue,

advanced #window-functions#ranking#reports

PandaDev

Services

App Catalogue

Learn

Company

Help

Change language

Snippet library

Running total

Top N per group