如何基于第一行创建第二行 [英] How to create second row based on first row

问题描述

How to create second row based on first row

Glno Lno提款WithDate Colletate余额余额

456 45 25000 01/01/2012 5000 10/01/2012 20000
456 45 20000 10/01/2012 10000 15/01/2012 10000


实际上，我的表中有第一行
我需要发送行，因为第一行的完成日期的值是发送行的撤回日期，余额是第二行的drw金额

如何基于第一行值添加第二行

Glno Lno Withdraw WithDate Colletion CollDate Balance

456 45 25000 01/01/2012 5000 10/01/2012 20000
456 45 20000 10/01/2012 10000 15/01/2012 10000


Actually first row is there in my table
I need the send row as values of first row colletion date is send row withdraw date and Balance amount is second row withdrw amount

How to add second row based on first row values

推荐答案

INSERT INTO table
SELECT t.Field1, t.Field2, t.Field3, 500, 700
FROM table t
WHERE t.ID = Row1

这篇关于如何基于第一行创建第二行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！