当我尝试运行查询来查找sesison create在一天内30天的总计数时

ctehm74n 于 2021-06-18 发布在 Mysql

关注(0)|答案(1)|浏览(241)

SELECT list is not in GROUP BY clause and contains nonaggregated column 'us.sessions'
which is not functionally dependent on columns in GROUP BY clause

我正在运行的查询，以查找一个月的会话计数天数。

SELECT
    us.sessions, us.avg_duration, us.sessions_date
FROM
    user_master um
        INNER JOIN
    user_institution_mapping uim ON um.id = uim.user_id
        INNER JOIN
    user_sessions us ON (us.user_id = um.id)
WHERE
    um.status = '1' AND uim.status = '1'
        AND uim.institution_id IN (26)
        AND us.sessions_date >= '2018-09-24'
        AND us.sessions_date <= '2018-10-25'
        AND uim.permission = 'all'
        group by sessions_date

mysql

来源：https://stackoverflow.com/questions/52987252/when-i-try-to-run-query-to-find-the-total-count-for-sesison-create-in-single-day

1条答案

按热度按时间

anauzrmj1#

更正上述错误的查询

SELECT sessions_date , SUM(sessions)
FROM
    user_master um
        INNER JOIN
    user_institution_mapping uim ON um.id = uim.user_id
        INNER JOIN
    user_sessions us ON (us.user_id = um.id)
WHERE
    um.status = '1' AND uim.status = '1'
        AND uim.institution_id IN (26)
        AND us.sessions_date >= '2018-09-24'
        AND us.sessions_date <= '2018-10-25'
        AND uim.permission = 'all'
        group by sessions_date

赞(0）回复(0）举报 2021-06-18

我来回答

当我尝试运行查询来查找sesison create在一天内30天的总计数时

1条答案

相关问题

热门标签

最新问答