摘要:
编辑器加载中... alter view V_OnlineCountArg as select avg(count) count , xDate from (select a.[count],convert(nvarchar(100),a.gettime,23) xDate, row_number() over(partition by convert(nvarchar(100),a.gettime,23) order by a.[count] desc, convert(nvarchar(100),a.gettime,23)) rn fro... 阅读全文