Çó½âÒ»½Ï¸ßÄѶÈSQLÓï¾ä

a  b
1  1
3  4
5  9
6  15

aÁÐ ÊÇÊý¾Ý¿âÊý¾Ý
Ïë²éѯ³öbÁУ¬bÊÇaµÄÿ¸ö¼Ç¼µÄÀÛ¼ÆÁÐ

---

SQL code:
select a,b=(select sum(a) from tb where a<=t.a)
from tb as t

---

ÒýÓÃ

SQL codeselect a,b=(selectsum(a)from tbwhere a <=t.a)from tbas t

Âäºó¿©£¡

---

SQL code:
create table TT
(
a int,
b int
)
insert into TT select 1,1
insert into TT select 3,4
insert into TT select 5,9
insert into TT select 6,15

create proc Get_B
(
@a int
)
as
select identity(int,1,1) ID,* into #1 from TT
select sum(a) from #1 where ID<=(select ID from #1 where a=@a)

--µ±aµÈÓÚ5
exec Get_B 5

-----------
9

---

Áº¸ç
ÓÖ³öÀ´»î¶¯À²

---

¾­µä

---

SQL code:
--> Éú³É²âÊÔÊý¾Ý±í:tb

IF NOT OBJECT_ID('[tb]') IS NULL
DROP TABLE [tb]
GO
CREATE TABLE [tb]([a] INT,[b] INT)
INSERT [tb]
SELECT 1,1 UNION ALL
SELECT 3,4 UNION ALL
SELECT 5,9 UNION ALL
SELECT 6,15
GO
--SELECT * from [tb]

-->SQL²éѯÈçÏÂ:

select a.a,SUM(b.b) b
from tb a
left join tb