第1个回答 2007-06-18
select sum(nashuie) from tableName where kesuo='一科'
select sum(nashuie) from tableName where kesuo='二科'
第2个回答 2007-06-18
select kesuo,sum(nashuie) from 表名 group by kesuo
第3个回答 2007-06-18
select kesuo,sum(nashuie) from 表名 group by kesuo