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

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

T-SQL

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

T-SQL | Data Cleaning

8
left join LATERAL
SQL

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

6
median
SQL

5
SQL window function II: percent growth
SQL

5
EXISTS
SQL

4
SQL creating a view
SQL

4
SQL window function
SQL

4