177. Nth Highest Salary

Tutd Schema:

 employee := relation{id Integer, salary Integer}{
  tuple{id 1, salary 100},
  tuple{id 2, salary 200},
  tuple{id 3, salary 300}};

Thinking Process:

-- nth highest salary

:showdataframe employee{salary} orderby {salary descending} offset n-1 limit 1

-- Right now, we don't have function definition like "getNthHighestSalary n = employee{salary} orderby {salary descending} offset (n-1) limit 1"

 

留言

張貼留言

這個網誌中的熱門文章

LeetCode 184. Department Highest Salary

Tutd Schema: employee :: {id Integer, name Text, salary Integer, departmentId Integer}; employee := relation{tuple{id 1, name "Joe", salary 70000, departmentId 1},                     tuple{id 2, name "Jim", salary 90000, departmentId 1},                     tuple{id 3, name "Henry", salary 80000, departmentId 2},                     tuple{id 4, name "Sam", salary 60000, departmentId 2},                     tuple{id 5, name "Max", salary 90000, departmentId 1}}; key employee_pkey {id} employee; department :: {id Integer, name Text}; department := relation{tuple{id 1, name "IT"}, tuple{id 2, name "Sales"}} key department_pkey {id} department; Thinking Process: TutorialD (master/main): grouped := employee group ({all but departmentId} as byDepartment)  TutorialD (master/main): :showexpr grouped ┌───────────────────────────────────────────────────────────────┬─────────────────────┐                                 
閱讀完整內容