请教高手这个SQL语句怎么写?我有一个表,里面有三个字段,一个字段是时间[posttime],另一个字段是用户ID[UID],还有一个字段是帖子ID[ID],我
我有一个表,里面有三个字段,一个字段是时间[posttime],另一个字段是用户ID[UID],还有一个字段是帖子ID[ID],我想实现这样的查询,用一个SQL语句查出今天之内哪位用户发的帖子最多,请问该怎么办 问题点数：0、回复次数：5Top
1 楼oyzjin（oyzjin）回复于 2004-12-04 22:43:41 得分 0
SELECT count( id)
FROM table
GROUP BY uid where posttime=(curdate()+1-1)Top
2 楼oyzjin（oyzjin）回复于 2004-12-04 22:48:34 得分 0
SELECT count( id) as counter
FROM table
GROUP BY uid where posttime=(curdate()+1-1) order by counter desc
Top
3 楼oyzjin（oyzjin）回复于 2004-12-04 22:50:32 得分 0
SELECT count( id) as counter
FROM table
GROUP BY uid where posttime=(curdate()+1-1) order by counter desc limit 0,1
(curdate()+1-1)这个值要具体到你posttime的格式了Top
4 楼mathematician（数学家）回复于 2004-12-05 20:22:15 得分 0
SELECT uid,count(id) as counter,posttime
FROM table_name
WHERE posttime=curdate() GROUP BY uid ORDER by counter desc limit 1;Top
5 楼cloudchen（cloudchen）回复于 2004-12-06 10:56:43 得分 0
select count(*),uid from 表 where posttime between concat(cast(now() as char(10)),' 00:00:00') and concat(cast(now() as char(10)),' 23:59:59') group by uid order by 1 limit 1Top
