求一SQL语句，数据查询，只剩30分了(30)

灵成 · 2009-08-02

表id userid total1 8 32 8 43 8 34 6 25 6 16 7 87 8 9怎样查询才能统计显示userid total2 8 19 6 3 7 8access下

cuit421 · 2009-08-02

SELECT userid, SUM(total) AS total2FROM 表GROUP BY userid

violetxh · 2009-08-02

这个问题太简单了！兄弟要多看看书！SELECT userid, SUM(total) AS total2FROM 表GROUP BY userid

贝尔 · 2009-08-02

SELECT userid, SUM(total) AS total2FROM 表GROUP BY useridORDER BY userid desc

qiyafei · 2009-08-03

('select userid,sum(total) from 表名 group by userid');

china_peng · 2009-08-03

select userID, sum(total) as total from 表 group by user_id order by min(ID)

梦缘 · 2009-08-04

select userid,sum(total) as total2 from 表名order by userid desc

keepyea · 2009-08-10

拖出去打!!

johnneo · 2009-08-10

我的答案和楼上各位一样

hunterII · 2009-08-10

用group by就可以，建议楼主多问问身边同事或是查查SQL帮助，很实用的

cuit421 · 2009-08-18

晕，都只问但不结贴。打消积极性啊

asonlife · 2009-08-18

selectuserid, sum(total) as total2from tablenamegroup by useridorder by userid desc

hewenyuan77 · 2009-08-21

同意楼上的。我的答案也一样。还是要多看看书。这个问题太简单了。

gigijava · 2009-09-09

select UserID, Sum(total) as Total from TableName group by user_id order by min(ID)

cwbcherish · 2009-09-26

要多学习多思考