tag

#dense-rank

2 pages tagged

Practice › LeetCode › LeetCode (archived) › LeetCode 01xx ›

LeetCode 185: Department Top Three Salaries

Problem Restatement We are given two tables: Employee and Department . Employee stores employee information. Column Type id int name varchar salary int departmentId int Department stores department information. Column Type id int name varchar Each employee belongs to a department through Employee.departmentId . We need to find employees who are high earners in their department. A high earner is an employee whose salary is in the top three unique...

Practice › LeetCode › LeetCode (archived) › LeetCode 01xx ›

LeetCode 178: Rank Scores

Problem Restatement We are given a table named Scores . Column Type id int score decimal Each row stores the score of a game. We need to rank all scores from highest to lowest. The ranking rules are: Rule Meaning Higher score gets smaller rank The highest score has rank 1 Equal scores share the same rank Two 4.00 scores both get rank 1 No rank gaps After rank 1...