[quote=引用 3 楼 QQ114152850的回复:]假设这个表有key值id,第一列是f1,第二列是f2,sql如下SELECT f1,f2,(select sum(f2) from table1 where f1=a.f1 and id<=a.id) AS f3 FROM table1 AS a ORDER BY f1;
SELECT f1,f2,(select sum(f2) from table1 where f1=a.f1 and id<=a.id) AS f3 FROM table1 AS a ORDER BY f1;
假设这个表有key值id,第一列是f1,第二列是f2,sql如下SELECT f1,f2,(select sum(f2) from table1 where f1=a.f1 and id<=a.id) AS f3 FROM table1 AS a ORDER BY f1;
7,714
社区成员
28,799
社区内容
加载中
试试用AI创作助手写篇文章吧