摘要：
184. Department Highest Salary The Employee table holds all employees. Every employee has an Id, a salary, and there is also a column for the departme 阅读全文
摘要：
181. Employees Earning More Than Their Managers The Employee table holds all employees including their managers. Every employee has an Id, and there i 阅读全文
摘要：
Write a SQL query to rank scores. If there is a tie between two scores, both should have the same ranking. Note that after a tie, the next ranking num 阅读全文
摘要：
Write a SQL query to get the nth highest salary from the Employee table. For example, given the above Employee table, the nth highest salary where n = 阅读全文
摘要：
Write a SQL query to get the second highest salary from the Employee table. For example, given the above Employee table, the query should return 200 a 阅读全文