[此贴子已经被作者于2016-1-26 23:33编辑过]
sele 编号,村别,姓名,商品,0.00 数量,0,00 单价,sum(积分) 积分,帐户,备注 from 表 grou by 村别
SELECT 编号,村名,姓名,商品,SUM(数量),单价,SUM(积分),SUM(帐户) FROM Tabl1 GROUP BY 编号,村名,姓名,商品 ORDER BY 编号,村名,姓名,商品
SELECT 数量 FROM 表 INTO CURSOR temp readw ALTER TABLE temp alter COLUMN 数量 N(4)