database
cocolalala
这个作者很懒,什么都没留下…
展开
-
[leetcode] Department Top Three Salaries
简单连接统计~~ select d.Name as Department, ee.Name as Emplyee, ee.Salary as Salary from Department d,( select * from Employee e where (select count(distinct Salary) from Employee where原创 2015-01-26 17:36:54 · 1180 阅读 · 0 评论 -
[leetcode] Consecutive Numbers
用用户变量记录出现次数即可~ select distinct NUM from( select NUM, @count := if(@prevNum = NUM, @count + 1, 1) as cnt, @prevNum := NUM from Logs, (select @prevNum := NULL) pn, (select @count := 0) ct o原创 2015-01-22 16:28:04 · 1573 阅读 · 0 评论