[leetcode][Database][Hard] 569. Median Employee Salary

1 · ZhengWei, Liu · Dec. 6, 2022, 4:48 p.m.
題目 Table: Employee +--------------+---------+ | Column Name | Type | +--------------+---------+ | id | int | | company | varchar | | salary | int | +--------------+---------+ id is the primary key column for this table. Each row of this table indicates the company and the salary of one employee. Write an SQL query to find the rows that contain the median salary of each company. While calculating the...