Start a project

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

1 snippets

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