Tag

#Window Functions

Every article tagged Window Functions, in one place.

2 articles
2 min of reading
18 Aug, 2026 last updated

Showing 2 articles

SQL 1 min read

SQL Interview Question: Find the Nth Highest Salary

A favourite interview question: given employees(id, name, department, salary) , find the Nth highest salary. Mention how you handle ties and missing values. 1. DISTINCT with LIMIT/OFFSET -- 3rd highest distinct salary SELECT DISTINCT salary FROM employees ORDE...

18 Aug, 2026 Author 959 117

Read article

SQL 1 min read

SQL Interview Question: ROW_NUMBER vs RANK vs DENSE_RANK

Short answer: all three number rows in a given order. They differ only in how they handle ties. SELECT name, score, ROW_NUMBER() OVER (ORDER BY score DESC) AS row_num, RANK() OVER (ORDER BY score DESC) AS rnk, DENSE_RANK() OVER (ORDER BY score DESC) AS dense F...

13 Apr, 2026 Author 321 115

Read article