2017年8月27日
184. Department Highest Salary【leetcode】sql，join on
摘要： 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 阅读全文
posted @ 2017-08-27 21:42 这个手杀不太0 阅读(239) 评论(0) 推荐(0)
181. Employees Earning More Than Their Managers【leetcode】,sql，inner join ，where
摘要： 181. Employees Earning More Than Their Managers The Employee table holds all employees including their managers. Every employee has an Id, and there i 阅读全文
posted @ 2017-08-27 21:05 这个手杀不太0 阅读(192) 评论(0) 推荐(0)
178. Rank Scores【leetcode】,sql
摘要： 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 阅读全文
posted @ 2017-08-27 20:32 这个手杀不太0 阅读(410) 评论(0) 推荐(0)
177. Nth Highest Salary【leetcode】，第n高数值，sql，limit，offset
摘要： 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 = 阅读全文
posted @ 2017-08-27 20:06 这个手杀不太0 阅读(190) 评论(0) 推荐(0)
176. Second Highest Salary【取表中第二高的值】，sql，limit，offset
摘要： 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 阅读全文
posted @ 2017-08-27 20:02 这个手杀不太0 阅读(543) 评论(0) 推荐(0)