Rank within groups

• Snippet
• SQL
• 4 blanks to fill

SELECT *
FROM (
  SELECT *, ROW_NUMBER() OVER (PARTITION BY Group ORDER BY Order DESC) AS rn
  FROM Table
) t
WHERE rn <= 3;

About this template

Top per group.

Category

Code snippets

Pack

SQL

Type

Snippet, a short message

Asks for

Group, Order, Table, N

Use it anywhere you write: email, chat, a document or a support tool. If you send it often, save the finished text as a snippet in ClipBuddy and paste it again from your clipboard history with ⌘⇧V.

SELECT *
FROM (
  SELECT *, ROW_NUMBER() OVER (PARTITION BY {{Group}} ORDER BY {{Order}} DESC) AS rn
  FROM {{Table}}
) t
WHERE rn <= {{N=3}};

More code snippets templates

• Common table expression Snippet WITH query.
• Insert row Snippet Insert values.
• Update rows Snippet Update with where.
• Delete safely Snippet Check first, then delete.
• Create table Snippet New table.
• Add index Snippet Speed up lookups.

See all 268 code snippets templates