SQL RANK

SQL

https://www.codewars.com/kata/58094559c47d323ebd000035/train/sql

SELECT p.id, 
        p.name, 
        COUNT(s.sale) sale_count,
        RANK () OVER ( 
            ORDER BY COUNT(s.sale) DESC
          ) sale_rank
FROM people p JOIN sales s ON p.id=s.people_id
GROUP BY p.id, p.name
changjulian17
Did you find this snippet useful?

Sign up for free to to add this to your code library

Getting the Last Record Using Rank Function - T-SQL Example
SQL

T-SQL

50
Getting the Date for the Previous Saturday with T-SQL
SQL

T-SQL

42
Remove Leading Zeros from a Field with T-SQL
SQL

T-SQL | Data Cleaning

17
SQL generate_series, dayofweek(DOW), weekday, functions
SQL

12
median
SQL

11
left join LATERAL
SQL

11
SQL window function
SQL

10
EXISTS
SQL

10
SQL creating a view
SQL

10
SQL window function II: percent growth
SQL

10