首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > SQL Server >

请教如何筛选这种条件的数据

2012-09-29 
请问怎么筛选这种条件的数据。select b.LoanBackBlank,a.ContractNm,SUM(a.RepayAmount)-SUM(a.receivableA

请问怎么筛选这种条件的数据。
select b.LoanBackBlank,a.ContractNm,SUM(a.RepayAmount)-SUM(a.receivableAmount) repaymoney,b.CustomNm,b.LoanBkAccount,b.LoanBkBank,b.LoanBkBankID,b.CustomType,b.LoanBackBlank 
 from InterestReceive a,OPSInf b where a.ContractNm=b.LoanNm 
 group by b.LoanBackBlank,a.ContractNm,b.CustomNm,b.LoanBkAccount,b.LoanBkBank,b.LoanBkBankID,b.CustomType 

SQL提取出来的数据,是包含repaymoney=0的数据,怎么才能让他大于等于0.01的数据才筛选出来。

[解决办法]
select b.LoanBackBlank,a.ContractNm,SUM(a.RepayAmount)-SUM(a.receivableAmount) repaymoney,b.CustomNm,b.LoanBkAccount,b.LoanBkBank,b.LoanBkBankID,b.CustomType,b.LoanBackBlank
 from InterestReceive a,OPSInf b where a.ContractNm=b.LoanNm
 group by b.LoanBackBlank,a.ContractNm,b.CustomNm,b.LoanBkAccount,b.LoanBkBank,b.LoanBkBankID,b.CustomType
having SUM(a.RepayAmount)-SUM(a.receivableAmount)>=0.01
[解决办法]

SQL code
having SUM(a.RepayAmount)-SUM(a.receivableAmount)>=0.01 

热点排行