4 to fix

Removed 0

query

RESULTSET

query
	CDR_RECORDID	DOLLARAMT	DUPECOUNT	INVOICEDATE	SKUID
1	5948	0.00	2	2022-07-25 00:00:00.0	2915602
2	245688	0.00	2	2021-07-13 00:00:00.0	10763
3	247011	0.00	2	2021-02-09 00:00:00.0	2915623
4	247179	0.00	2	2022-04-21 00:00:00.0	10246

CACHED

false

EXECUTIONTIME

1584

SQL

select cdr_recordId, invoiceDate, skuId, dollarAmt, count(*) dupeCount from tbl_CDR_InvoiceHistory where invoiceNumber like 'REDIST%' and ownerId = 54 and ownerType = 'MFR' group by cdr_recordId, invoiceDate, skuId, dollarAmt having count(*) > 1 order by cdr_recordId, invoiceDate, skuId