2020年2月11日
178. Rank Scores
摘要： 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 @ 2020-02-11 19:05 hyx1 阅读(112) 评论(0) 推荐(0)
177. Nth Highest Salary
摘要： Write a SQL query to get the nth highest salary from the Employee table. + + + | Id | Salary | + + + | 1 | 100 | | 2 | 200 | | 3 | 300 | + + + For exa 阅读全文
posted @ 2020-02-11 18:22 hyx1 阅读(117) 评论(0) 推荐(0)
176. Second Highest Salary
摘要： Write a SQL query to get the second highest salary from the Employee table. + + + | Id | Salary | + + + | 1 | 100 | | 2 | 200 | | 3 | 300 | + + + For 阅读全文
posted @ 2020-02-11 18:05 hyx1 阅读(111) 评论(0) 推荐(0)
175. Combine Two Tables
摘要： Table: Person + + + | Column Name | Type | + + + | PersonId | int | | FirstName | varchar | | LastName | varchar | + + + PersonId is the primary key c 阅读全文
posted @ 2020-02-11 17:21 hyx1 阅读(121) 评论(0) 推荐(0)