一个sql语句，大家帮帮忙
0
其他回答(7)
0
这个好像用到TSql的语句.具体怎样做我也不知道.
0
select * from 表 where count=(SELECT Max(count) as B1 FROM 表)
查询出吃方便面最多的人
0
SELECT TOP 1 name
FROM TEST
WHERE time BETWEEN '2009-4-1' AND '2009-5-1'
GROUP BY name
ORDER BY SUM(count) DESC
好像是这样的，谢谢
0
count 是关键字吧，能这样直接用？
0
SELECT name ,sum(count) as counts FROM TEST
WHERE time BETWEEN begintime AND endtime
GROUP BY name
ORDER BY counts DESC
这应该在sql 中是最简单的了..呵呵...试试...吧...大体样子就是这样了
是的，谢谢了。这个比较通用。没有top那种某些数据库才有的关键字
0
厉害，
？
0
集合楼上精华。绝对正解 SELECT top 1 name ,sum(count) as counts FROM TEST WHERE time BETWEEN begintime AND endtime GROUP BY name ORDER BY counts DESC
great
0
楼上正解。