SELECTCOUNT(w.invoiceId)AS'10Days'FROMtbl_InvoicewWHEREw.invoiceIdNOTIN(SELECTinv.invoiceIdFROMtbl_InvoiceAllocationinv)ANDw.invoiceDate它工作正常并返回日期超过10天前的所有发票的计数。我现在想在同一查询中返回超过20天和100天的发票计数。所以理想情况下，查询会返回如下内容:10Days20Days100Days35028090 最佳答案 将COUNT改为SUM，将指定的WHERE子句作为CASE

所以我有一个看起来像这样的插页:INSERTINTOTempDupeData(Sys_InvoiceID,DupeSetID,Netted,InvoiceNo,InvoiceDate,Sys_SupplierID,SuppInvNo,NetAmount,VATAmount,GrossAmount,PayDate,PayRef,PayRefNo,PayType,PayAmount,Curr,GBPNetAmount,GBPVATAmount,GBPGrossAmount,NetAmountAbs,GrossAmountAbs,VATAmountAbs,DocType,SuppInvNoN