不使用crosstab实现PostgreSQL的行转列应用

发布时间：2020-12-13 17:25:11 所属栏目：百科来源：网络整理

导读：表结构及数据 select logdatetime,sum(login) as login,sum(logo) as logo from( SELECT date(logdatetime) AS "logdatetime",case logfrom when 'login' then COUNT(id) else 0 end AS "login", case logfrom when 'logo' then COUNT(id) else 0 end AS "lo

表结构及数据

select logdatetime,sum(login) as login,sum(logo) as logo

from(
SELECT date(logdatetime) AS "logdatetime",case logfrom when 'login' then COUNT(id) else 0 end AS "login",
case logfrom when 'logo' then COUNT(id) else 0 end AS "logo"
FROM "log" WHERE date(logdatetime) >= '2014-11-04' AND date(logdatetime) <= '2014-11-05' GROUP BY "logdatetime","logfrom"
) T
GROUP BY "logdatetime"

ORDER BY "logdatetime" ASC

执行结果

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!