![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MySQL
dashalen
这个作者很懒,什么都没留下…
展开
-
MySQL分组取top n
1.SQL SELECT sheetDate, goodsId, goodsName, payOrderNum, actualTotalAmount FROM ( SELECT @row_number = 0, (@row_number := CASE WHEN @sheetDate = sheetDate THEN @row_number + 1 ELSE 1 END) AS num, @...原创 2019-12-05 16:39:30 · 260 阅读 · 0 评论 -
MySQL时间范围排序
背景:查询一个表的活动信息,排序方式 活动期间 > 未开始活动 > 已结束活动 SELECT * FROM test.activity t where deleteFlag = 0 order by (case when t.beginTime <= now() and now() < t.endTime then 1 else 0 end) desc, (case wh...原创 2019-07-12 23:51:18 · 857 阅读 · 0 评论 -
MySQL查询交集
背景:查询该活动时间范围内是否有存在的活动(交集) SELECT * FROM activity WHERE deleteFlag = FALSE AND ( (beginningTime <= #{startTime} AND closingTime > #{startTime}) OR (beginningTime <= #{endTime} AND closingTi...原创 2019-09-04 13:09:51 · 919 阅读 · 0 评论