← Barclays questions
CodingReported in a candidate post, Jul 2025

SQL with DENSE_RANK, and RANK vs DENSE_RANK

Filed under Barclays

Write an SQL query that needs the DENSE_RANK() window function, then explain the difference between RANK() and DENSE_RANK(). The exact table in the test was not recorded; a typical use is finding the…

You've read your 3 free write-ups

Sign up free to keep reading. Your account opens the first 10 questions of every company.

Related Barclays questions

Collected from public candidate posts and coding forums. Updated Nov 2026.