select count(*) as a from bbs
group by day(dattime);
结果如下
---------------------------------
a
11
12
8
4
1
1
1
1
现在问有没有办法把最大值求出,用select语句!
group by day(dattime);
结果如下
---------------------------------
a
11
12
8
4
1
1
1
1
现在问有没有办法把最大值求出,用select语句!
group by day(dattime)) t
Select Max(a) From
(Select count(*) as a from bbs
group by day(dattime)) A
select count(*) as a from bbs
group by day(dattime)
) x
select count(*) as a from bbs
group by day(dattime))t;
Select TOP 1 count(*) as a from bbs
group by day(dattime)
Order By a Desc
楼上的是不是有新贴子提示之类的东东?
----
手动
(
select count(*) as a from bbs
group by day(dattime)
) t