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"

 

留言

張貼留言

這個網誌中的熱門文章

185. Department Top Three Salaries

Tutd Schema: employee :: { id Integer, name Text, salary Integer, departmentId Integer}; employee := relation{  tuple{id 1, name "Joe", salary 85000, departmentId 1},  tuple{id 2, name "Henry", salary 80000, departmentId 2},  tuple{id 3, name "Sam", salary 60000, departmentId 2},  tuple{id 4, name "Max", salary 90000, departmentId 1},  tuple{id 5, name "Janet", salary 69000, departmentId 1},  tuple{id 6, name "Randy", salary 85000, departmentId 1},  tuple{id 7, name "Will", salary 70000, departmentId 1}}; key employee_ukey {id} employee; department := relation{id Integer, name Text}{tuple{id 1, name "IT"}, tuple{id 2, name "Sales"}}; key department_ukey {id} department; Thinking Process: -- DataFrame -> Relation is needed to bring top 3 back to a set -- "map" departmentId by hand topThreeDep1 := (:showdataframe ((employee where departmentId = 1){salary}) orderby {salary desce
閱讀完整內容