请问怎么筛选这种条件的数据。

Question

 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的数据才筛选出来。

Answer 1

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

Answer 2

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

Answer 3

这里应该用where吧。
就我所知，这种情况下用having效率相对来说会比较低。