SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

8 rows affected

id	amount	openamt	debamt	credamt	closeamt
1	20	340	140	200	400
2	20	340	140	200	400
3	20	340	140	200	400
4	30	340	140	200	400
5	100	340	140	200	400
6	20	340	140	200	400
7	30	340	140	200	400
8	100	340	140	200	400

id	amount	openamt	debamt	credamt	closeamt
1	20	340	140	200	400
2	20	340	140	200	400
3	20	340	140	200	400
4	30	340	140	200	400
5	100	340	140	200	400
6	20	340	140	200	400
7	30	340	140	200	400
8	100	340	140	200	400

id	amount	openamt	debamt	credamt	closeamt
1	20	340	140	200	400
2	20	340	140	200	400
3	20	340	140	200	400
4	30	340	140	200	400
5	100	340	140	200	400
6	20	340	140	200	400
7	30	340	140	200	400
8	100	340	140	200	400

id	amount	openamt	debamt	credamt	closeamt
1	20	340	140	200	400
2	20	340	140	200	400
3	20	340	140	200	400
4	30	340	140	200	400
5	100	340	140	200	400
6	20	340	140	200	400
7	30	340	140	200	400
8	100	340	140	200	400