Sql 第一行某列减第二行某列,
--1. 将结果插入临时表
SELECT
*
INTO xxx
FROM(
SELECT TOP 1 a.FQTY,a.fseq
FROM T_SAL_ORDERENTRY as a
WHERE FQTY=5
UNION ALL
SELECT TOP 1 b.FQTY,b.fseq
FROM T_SAL_ORDERENTRY as b
WHERE FQTY=1
) as c
SELECT * FROM xxx
--最初update
-- UPDATE xxx
-- SET FQTY = ISNULL((
-- SELECT TOP 1 a.FQTY
-- FROM xxx AS a
-- WHERE t.fseq >= fseq
-- AND FQTY=5
-- )-(
-- SELECT TOP 1 b.FQTY
-- FROM xxx AS b
-- WHERE t.fseq <fseq
-- AND FQTY=1
-- ),0)
-- FROM xxx AS t
--将记录1减记录2 ,新增至第3行
INSERT INTO xxx
SELECT ISNULL((
SELECT TOP 1 a.FQTY
FROM xxx AS a
WHERE t.fseq >= fseq
AND FQTY=5
)-(
SELECT TOP 1 b.FQTY
FROM xxx AS b
WHERE t.fseq <fseq
AND FQTY=1
),0),t.fseq
FROM xxx AS t
WHERE fseq=1
SELECT * FROM xxx
DROP TABLE xxx
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。