select regdate,总PV,总点击,总独立用户,总停留时间 from
(SELECT RegDate, SUM(StayCount) AS '总PV', SUM(ClickSum) AS '总点击', SUM(StayTime) AS '总停留时间' FROM trafficsum GROUP BY RegDate) as a,
(SELECT COUNT(DISTINCT IP) AS '总独立用户' FROM traffic GROUP BY RegDate) as b
where a.regdate=b.regdate
(SELECT RegDate, SUM(StayCount) AS '总PV', SUM(ClickSum) AS '总点击', SUM(StayTime) AS '总停留时间' FROM trafficsum GROUP BY RegDate) as a,
(SELECT COUNT(DISTINCT IP) AS '总独立用户' FROM traffic GROUP BY RegDate) as b
where a.regdate=b.regdate
解决方案 »
- c#访问msyql,release下出现Unable to load DLL 'coredll',debug 正常运行
- mysql的并发问题
- MYSQL数据库update问题
- 求 能提取字段中数字的一个自定义函数
- 续论坛单日最高帖HQL语句
- 求C#实现对MYSQL数据库备份
- Can't create/write to file errcode 17如何解决?
- 求教,如果表中没有某字段,就增加这个段的sql该怎么写?
- 怎么在存储过程里查询的时候一起取到值,最好不要再次查询
- Foreign key constraint is incorrectly formed
- 在linux安装mysql怎么一点反映也没有。
- 请教,在SQL里截取字段
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT RegDate, SUM( StayCount ) AS 'a1', SUM( ClickSum ) AS 我的SQL如下:
SELECT RegDate, a1, a2, b1, a3 FROM (SELECT RegDate, SUM(StayCount) AS 'a1', SUM(ClickSum) AS 'a2', SUM(StayTime) AS 'a3' FROM trafficsum GROUP BY RegDate) AS a, (SELECT COUNT(DISTINCT IP) AS 'b1' FROM traffic GROUP BY RegDate) AS b WHERE a.RegDate = b.RegDate
drop table tmp2;