SELECT
(
CASE
WHEN platform_parameter IS NULL THEN
page
ELSE
platform_parameter
END
) AS page,
sum(pv) AS pv,
sum(uv) AS uv,
CAST(AVG(time) AS DECIMAL(10,2)) as time
FROM
t_page_stat_daily t
LEFT JOIN t_app_dictionary d ON t.app_id = d.app_id
AND t.page = d.interface_parameter
WHERE
t.app_id = '920024'
GROUP BY
t.page
MySQL 使用AVG聚合函数时,保留两位小数的方法
最新推荐文章于 2024-07-03 03:07:34 发布