SQL
anaitudou
这个作者很懒,什么都没留下…
展开
-
HIVE 高级应用(一)--COUNT 高级用法(条件过滤等)
在HIVE中,除了COUNT(*)外,COUNT还可以有很多高级用法。SELECT type , count(*) , count(DISTINCT u) , count(CASE WHEN plat=1 THEN u ELSE NULL END) , count(DISTINCT CASE WHEN plat=1 THEN u ELSE NULL END) , cou...原创 2018-05-30 09:11:42 · 10312 阅读 · 0 评论 -
Mysql统计排名
MYSQL实现统计排名建表预计CREATE TABLE `players` ( `pid` int(2) NOT NULL, `name` varchar(50) DEFAULT NULL, `age` int(2) DEFAULT NULL, `money` int(10) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;插入数...原创 2018-05-30 09:57:54 · 732 阅读 · 0 评论 -
mysql遇见Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre的问题
报错如下:Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘sss.month_id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible wit...转载 2018-06-26 09:45:18 · 111 阅读 · 0 评论