摘要: Write a SQL query to find all numbers that appear at least three times consecutively. For example, given the above Logs table, 1 is the only number th 阅读全文
posted @ 2017-01-21 05:13 lettuan 阅读(314) 评论(0) 推荐(0) 编辑
摘要: 参考: https://my.oschina.net/Tsybius2014/blog/493244 常见的排序1. 排名1,2,3,...,n 不对重复的分数做特殊处理 Score Rank 100 1 99 2 99 3 98 4 90 5 排序2. 相同分数排名相同,排名第n名表示前面有n-1 阅读全文
posted @ 2017-01-21 04:58 lettuan 阅读(578) 评论(0) 推荐(0) 编辑