是这个吗:
select a,日期,count(a) as cnt
from tb
group by a,日期
select a,日期,count(a) as cnt
from tb
group by a,日期
解决方案 »
- 如何最快的去掉重复的记录
- 求mysql, c 连接环境设置方法,win mingw gcc
- 请问怎样才能同时建了两个表的?
- REDHAT AS4 下MYSQL5.0修改用户密码后用PHP(mysql_connect)连接提示错误
- Struts+Mysql错误 问题困扰了好几天了。
- 请帮帮忙mysql 问题例如hot,我用什么命令取出ho后边的t?
- JDBC的驱动那里有下?(MySql的,当然最好还有其他的数据库的)谢谢各位高手!
- 如何查找一条记录的修改历史?
- MySQL在ASP,NET中遇到问题
- 左联查询时,右表有多条关联左表同一记录的信息,只要有右表中有条件不符合,就不显示该所有左表记录
- mysql的表里有没有一个相当于foxpro中记录号的东西?
- 好久没搞MYSQL了
from test group by a HAVING COUNT(*)>1
1 b1 2005-11-7
2 b1 2005-11-7
3 b4 2005-11-8
4 b1 2005-11-8
5 b2 2005-11-9
6 b1 2005-11-9
7 b1 2005-11-10
8 b1 2005-11-10
9 b1 2005-11-10可以看出b1在2005-11-10出现了3次,是最大数据,我要的就是这个
SELECT count(*) as degree,b,date1
from test group by date1 order by degree desc;
from (select b,max(c) as m
from (select b,dates,count(b) as c
from tb1
group by b,dates) q
group by b) s,
(select b,dates,count(b) as c
from tb1
group by b,dates) t
where s.m=t.c and s.b=t.b
1 b1 2005-11-7
2 b1 2005-11-7
3 b4 2005-11-8
4 b1 2005-11-8
5 b2 2005-11-9
6 b1 2005-11-9
7 b1 2005-11-10
8 b1 2005-11-10
9 b1 2005-11-10
10 b2 2005-11-10
11 b2 2005-11-10
13 b3 2005-11-10
14 b1 2005-11-10可以看出b1在2005-11-10出现了4次,是最大数据,我要按时间和b字段同时分组查询,最好是返回所有列?