56,678
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE tbl
(
id INT,
time DATE
);
INSERT INTO tbl(id, time) VALUES(1, '2009-06-07'), (1, '2009-06-07'), (1, '2009-06-07'),
(2, '2009-06-07'), (3, '2009-06-07'), (3, '2009-06-07'),
(3, '2009-06-07'), (1, '2009-06-08'), (2, '2009-06-08'),
(2, '2009-06-08'), (4, '2009-06-08'), (5, '2009-06-08');
select id, time, count(id) from tbl group by id, time order by time desc;
select max(id) from tbl group by time;
select count(id) from tbl group by time;