PostgreSQL ROW_NUMBER ranking

Hard 40 pts New · no attempts yet sql

Topics

Toolliyo edge

Rank employees by salary within each department using window functions.

Static hints

ROW_NUMBER() OVER (PARTITION BY ... ORDER BY ...)

Toolliyo Coach

Stuck? Get a nudge — not the answer

Progressive help: Nudge → Guide → Approach. Full solution stays behind the Solution tab.

Your solution

Editor is open — no login wall to practice.

Ready — edit the code above and click Run or Submit.

Official solution

-- PostgreSQL schema
CREATE TABLE employees (id SERIAL PRIMARY KEY, name TEXT, dept_id INT, salary NUMERIC(10,2));
CREATE TABLE departments (id SERIAL PRIMARY KEY, name TEXT);
INSERT INTO employees (name, dept_id, salary) VALUES ('Ali',1,90000),('Sara',2,120000);
INSERT INTO departments (name) VALUES ('Engineering'),('Sales');
SELECT name, salary, dept_id,
       ROW_NUMBER() OVER (PARTITION BY dept_id ORDER BY salary DESC) AS rn
FROM employees;

Prefer Coach (Nudge → Guide → Approach) before revealing. No forced signup.

Explanation

Window functions: PARTITION BY groups, ORDER BY ranks within group.

Next All problems

PostgreSQL ROW_NUMBER ranking

Stuck? Get a nudge — not the answer

Your solution

Official solution

Explanation

Your submissions

Discussion