- 博客(4)
- 资源 (3)
- 收藏
- 关注
原创 postgresql 计算时间差
按日期计算天数差# select (('2019-11-18 12:05'::timestamp)::date - ('2019-10-18 12:05'::timestamp)::date) as day; day ----- 31# select (('2019-11-18 00:05'::timestamp)::date - ('2019-10-18 12:05'::times...
2019-10-18 11:59:31 9689
原创 postgresql SQL COUNT(DISTNCT FIELD) 优化
引用引自文章1:https://www.cnblogs.com/wangzhen3798/p/7630602.html引自文章2:https://www.jb51.net/article/65680.htm感谢前辈们趟坑分享。背景统计某时段关键词的所有总数,也包含null (statistics 有400w+的数据,表大小为 600M),故写出sql:select count(d...
2019-10-12 15:54:37 1585
原创 redis 报错 Failed to start Advanced key-value store.
Redis 报错: Failed to start Advanced key-value store.dpkg: error processing package redis-server (--configure): installed redis-server package post-installation script subprocess returned error exit ...
2019-10-08 21:24:32 7458
炫酷滑动效果(css/jquery)
2015-10-29
Visual C++6.0(vc6.0)助手
2014-08-07
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人