求一SQL语句

按要求统计下面两个字段

F_Bh F_Je
1 10
2 20
3 10
5 50
6 10
8 10
9 20

要求得到结果如下

Bh1 Bh2 Je
1 3 40
5 6 60
8 9 30

F_Bh 编号连续的则统计一次，并且记录其实编号和终止编号

---

有意思

---

不明白

---

SQL code:
/*
*************************************
* T-MAC 小编 *
* -->努力成长中 *
* -->梦想DBA *
*************************************
*/
if OBJECT_ID('tb') is not null
drop table tb
go
create table tb (F_Bh int, F_Je int)
insert tb select
1 ,10 union select
2 ,20 union select
3 ,10 union select
5 ,50 union select
6 ,10 union select
8 ,10 union select
9 ,20

select Bh1=MIN(f_bh),
Bh2=MAX(f_bh),
Je=SUM(f_je)
from (
select rn=ROW_NUMBER() over(order by f_bh)-f_bh,* from tb) k
group by rn
order by Bh1

(7 行受影响)
Bh1 Bh2 Je
----------- ----------- -----------
1 3 40
5 6 60
8 9 30

---

SQL code:
declare @t table(F_Bh int,F_Je int)
insert into @t select 1,10
insert into @t select 2,20
inser