22,209
社区成员
发帖
与我相关
我的任务
分享
create table #tb(XBBH int,ZBDJBH varchar(20),
ONE numeric(12,2),TWO numeric(12,2),GUANCI varchar(10))
insert into #tb
select 172753,'HNT00010163',616,255,'配比'
union all select 172754,'HNT00010163',643,278,'第1罐'
union all select 172755,'HNT00010163',616,255,'配比'
union all select 172756,'HNT00010163',604,292,'第2罐'
union all select 172757,'HNT00010163',1247,570,'累计值'
union all select 172758,'HNT00010163',1.22,11.76,'总误差%'
SELECT a.ZBDJBH,a.GUANCI
,b.ONE ONE配比,a.ONE ONE称重,CAST(100.*(a.ONE-b.ONE)/b.ONE AS decimal(10,2)) [ONE总误差%]
,b.TWO TWO配比,a.TWO TWO称重,CAST(100.*(a.TWO-b.TWO)/b.TWO AS decimal(10,2)) [TWO总误差%]
FROM #tb a
CROSS APPLY
(
SELECT TOP 1 * FROM #tb WHERE XBBH<a.XBBH ORDER BY XBBH desc
) b
WHERE a.GUANCI LIKE '第%'