会计分类帐余额 [英] Accounting Ledger balance

问题描述

嗨

我有一个交易表，其中包含

Hi
I have a transaction table that contains

LedgerName	DebitOrCredit	DebitAmount	CreditAmount	VoucherNo
Cash A/c	    Dr	          3000.00       	0.00	   1
Cash A/c	    Dr	          3000.00               0.00	   2
Axis Bank A/c       Cr             0.00         	3000.00	   2 
Cash A/c	    Dr	          700.00	        0.00	   6
 Orders A/c	    Cr	           0.00	               700.00	   6
Cash A/c	    Dr	          700.00	        0.00	  18
 Orders A/c	    Cr	           0.00	               700.00	  18
Cash A/c	    Dr	          700.00	         0.00	  54
Orders A/c	    Cr	           0.00	               700.00	  54
Cash A/c	    Dr            700.00	        0.00	  7
Orders A/c	    Cr	           0.00	               700.00	  7

如果我查询现金A / c，我的结果将是是

If I query for Cash A/c, my result would be

Axis Bank A/c       Cr              3000.00
 Orders A/c	    Cr               700.00
 Orders A/c	    Cr               700.00
 Orders A/c	    Cr               700.00
 Orders A/c	    Cr               700.00

请提供我的sql查询。

Please provide me the sql query.

推荐答案

尝试

Try

SELECT LedgerName, DebitOrCredit, CreditAmount FROM [YourTable]
WHERE VoucherNo IN
(
	SELECT VoucherNo FROM [YourTable]
	WHERE LedgerName = 'Cash A/c'
)
AND DebitOrCredit = 'Cr'

select LedgerName,DebitOrCredit,CreditAmount from table_name where DebitOrCredit=''Cr''

这篇关于会计分类帐余额的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！