select top 1 * from ( select v_view=sum(V_View),v_date=cast(V_DTime as datetime) from Stat_View where Site_ID=1 group by cast(V_DTime as datetime) order by v_view desc ) a--你的SQL语句中是先选出了一条语句,然后再排序的,所以不对 改一下,改成选排序后选
select top 1 * from ( select v_view=sum(V_View),v_date=cast(V_DTime as datetime) from Stat_View where Site_ID=1 group by cast(V_DTime as datetime) order by sum(V_View) desc ) a --上面错了,应该是这样
wrong : 除非同时指定了 TOP,否则 ORDER BY 子句在视图、内嵌函数、派生表和子查询中无效。
改为 select top 1 * from ( select top 1 v_view=sum(V_View),结果和上边的还是一样~
改为 select top 1 * from ( select top 1 v_view=sum(V_View),--把1改为行数
结果和 convert(varchar(19),V_DTime,120) 是一样的
125 2004-10-19 00:00:00access :
Expr1000 Expr1001
416 2004-10-18
select v_view=sum(V_View),v_date=cast(V_DTime as datetime)
from Stat_View
where Site_ID=1
group by cast(V_DTime as datetime)
order by v_view desc
) a--你的SQL语句中是先选出了一条语句,然后再排序的,所以不对
改一下,改成选排序后选
select v_view=sum(V_View),v_date=cast(V_DTime as datetime)
from Stat_View
where Site_ID=1
group by cast(V_DTime as datetime)
order by sum(V_View) desc
) a
--上面错了,应该是这样
select top 1 v_view=sum(V_View),结果和上边的还是一样~
select top 1 v_view=sum(V_View),--把1改为行数
楼主还是把表中数据都列出来吧,太多的话,发到我邮箱也行[email protected]
select top 100 percent v_view=sum(V_View),...