本文展示了一段SQL查询语句，用于从指定日期范围内筛选平台基础数据，计算每日的游戏数量和总游戏时长，并将结果按日期进行分组。此查询适用于数据分析场景，帮助理解特定时间段内的游戏活动趋势。
select convert(char(10),RECORDDT,120) as RECORDDT ,
sum(GAMECOUNT)as GAMECOUNT_sum ,sum(GAMETIME_H) as GAMETIME_H_sum
from tb_PlatformBaseData
where RECORDDT >='2011-11-28' and RECORDDT <='2011-12-01'
--where RECORDDT >='2011-11-28 0:00:00' and RECORDDT <='2011-12-01 23:59:59.999'
group by convert(char(10),RECORDDT,120)
sum(GAMECOUNT)as GAMECOUNT_sum ,sum(GAMETIME_H) as GAMETIME_H_sum
from tb_PlatformBaseData
where RECORDDT >='2011-11-28' and RECORDDT <='2011-12-01'
--where RECORDDT >='2011-11-28 0:00:00' and RECORDDT <='2011-12-01 23:59:59.999'
group by convert(char(10),RECORDDT,120)
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
