代码片段库

经过测试、可直接复制的 Python、Flask、JavaScript、SQL、HTML、CSS 和 Bash 代码片段，都可以在代码游乐场中打开。

只显示此浏览器中收藏的代码片段

2 个代码片段

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

服务

应用目录

学习

公司

帮助

切换语言

代码片段库

Running total

Top N per group