有自增长的id字段吗
Select (id-1)/10,sum(求和字段) From 表 Group By (id-1)/10追问没有自增的id,甚至没有主键
追答select sum(jine) From
(select row_number() over (order by RiQi,shijian) as newid,jine from journal) 表
Group By (newid-1)/10
测试的表叫journal,按照riqi和shijian字段进行了编号,只适用于sql server