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
1条答案
按热度按时间anauzrmj1#
更正上述错误的查询