2,209
社区成员
发帖
与我相关
我的任务
分享
string sqlF = @"
select
max(online_count) y,
trunc((create_time - to_date('{0}','YYYY-MM-DD HH24:MI:SS')) / {1}) relativeValue,
to_date('{0}','YYYY-MM-DD HH24:MI:SS') + (trunc((create_time - to_date('{0}','YYYY-MM-DD HH24:MI:SS')) / {1})) * {1} x
from
online_statistic
where
create_time > to_date('{0}','YYYY-MM-DD HH24:MI:SS') and create_time < to_date('{2}','YYYY-MM-DD HH24:MI:SS')
and (cpid,content_id,content_type) in (({3}))
group by
trunc((create_time - to_date('{0}','YYYY-MM-DD HH24:MI:SS')) / {1})
order by
x asc";
string sql = string.Format(sqlF, start, scaleUnit, end, contentIdentify);