SELECTACCOUNTCODE,DATE_,DEBIT,CREDIT, Sum([DEBIT] – [CREDIT]) OVER (PARTITION BY ACCOUNTREFORDER BY DATE_, LOGICALREF) AS [BAKIYE]FROM LG_990_01_EMFLINE
WHERE ACCOUNTCODE=’120.01.001′
Logo SQL
Comments are closed