sql
mecklenburg
这个作者很懒,什么都没留下…
展开
-
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 | 2 |原创 2016-12-16 10:00:57 · 247 阅读 · 0 评论 -
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 department Id.+----+-------+--------+--------------+ | Id | Name | Salary | DepartmentId原创 2016-12-17 10:29:20 · 339 阅读 · 0 评论