表ZILIAO中有字段XINGMING,SHULIANG,JINE等字段
现在要对JINE按XINGMING进行汇总:
我用TOTA ON JINER FIELDS XINGMING TO TEMP1
为什么TEMP1中没有按XINGMING进行汇总，？？
---------------------------------------------------------------
total on xingming fields jiner to temp1
---------------------------------------------------------------
表ZILIAO须按照XINGMING索引。并且会总时需要打开索引。
---------------------------------------------------------------
select *,sum(jine) from ziliao group by xingming
---------------------------------------------------------------
select XINGMING,sum(JINER) from zililao group by xingming
你只需要在SQL中加入分组的语句就可以了！
---------------------------------------------------------------
先对xingming 字段进行排序或索引
然后
total on xingming fields jiner to temp1