数据库
qq_34505594
这个作者很懒,什么都没留下…
展开
-
180. Consecutive Numbers
Write a SQL query to find all numbers that appear at least three times consecutively. +----+-----+ | Id | Num | +----+-----+ | 1 | 1 | | 2 | 1 | | 3 | 1 | | 4 | 2 | | 5 | 1 | | 6 | ...原创 2019-08-19 22:03:20 · 79 阅读 · 0 评论 -
177. Nth Highest Salary
Write a SQL query to get thenthhighest salary from theEmployeetable. +----+--------+ | Id | Salary | +----+--------+ | 1 | 100 | | 2 | 200 | | 3 | 300 | +----+--------+ For example...原创 2019-08-10 22:19:53 · 115 阅读 · 0 评论 -
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 number should be the next consecutive integer value. ...原创 2019-08-11 21:21:17 · 114 阅读 · 0 评论