SQL同列第1个值除以第5个值
SQL同列
第1个值除以第5个值
第2个值除以第6个值
第3个值除以第7个值
第4个值除以第8个值
第5个值除以第9个值
……
一直进行下去
[解决办法]
create table tb(v int)
insert into tb
select 1 union all
select 10 union all
select 6 union all
select 8 union all
select 2 union all
select 18 union all
select 5 union all
select 10 union all
select 11 union all
select 90
go
;with t
as
(
select *,
ROW_NUMBER() over(order by @@servername) rownum
from tb
)
select t1.*,t1.v *1.0/ t2.v as vv
from t t1
inner join t t2
on t1.rownum +4 = t2.rownum
/*
vrownumvv
110.500000000000
1020.555555555555
631.200000000000
840.800000000000
250.181818181818
1860.200000000000
*/
