![](https://img-blog.csdnimg.cn/20201014180756724.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
DataBase
simplehych
简单 快乐
展开
-
leecode-database 177. Nth Highest Salary
leecode地址链接 https://leetcode.com/problems/nth-highest-salary/description/ Write a SQL query to get the nth highest salary from the Employee table. 写SQL查询语句从Employee表中获取第N高的薪资 +----+--------+ | ...原创 2018-02-26 18:02:36 · 212 阅读 · 0 评论 -
leecode-database 178. Rank Scores
leecode地址链接 https://leetcode.com/problems/rank-scores/description/ 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, ...原创 2018-02-27 17:00:25 · 196 阅读 · 0 评论 -
leecode-database 175. Combine Two Tables - Left Join
leecode地址链接 https://leetcode.com/problems/combine-two-tables/description/ Table: Person 表:Person +-------------+---------+ | Column Name | Type | +-------------+---------+ | PersonId | int...原创 2018-02-24 10:49:03 · 177 阅读 · 0 评论 -
leecode-database 176.Second Highest Salary
Write a SQL query to get the second highest salary from the Employee table. 编写SQL查询语句从Employee表中获得第二高的薪资 +----+--------+ | Id | Salary | +----+--------+ | 1 | 100 | | 2 | 200 | | 3 | 300 ...原创 2018-02-24 14:29:46 · 171 阅读 · 0 评论