prabha_friend
Prabhakaran Karuppaih
- Local time
- Today, 15:41
- Joined
- Mar 22, 2009
- Messages
- 795
Table1 Table1
SELECT Table1.ID, Table1.Field1, Table1.Field2, (Select [Table1].[Field2] from [Table1] where [Table1].[Field1]<[Table1].[Field2]) AS Expr1
FROM Table1;
Expecting "Opening Balance"
ID | Field1 | Field2 |
---|---|---|
2 | 01-01-2022 | 500 |
3 | 02-01-2022 | 1100 |
4 | 03-01-2022 | 1700 |
FROM Table1;
Expecting "Opening Balance"