Select crsprod, crsitemcode, sum(crsrequestamt) as inreq, sum(crsaccptamt) as whsaccpt, Count(*) as cntdup From crs_grid1 ; > Group By crsprod, crsitemcode WHERE COUNT(*) > 1 INTO CURSOR dupcountHTH
Select crsprod, crsitemcode, sum(crsrequestamt) as inreq, sum(crsaccptamt) as whsaccpt, Count(*) as cntdup From crs_grid1 ; > Group By crsprod, crsitemcode WHERE cntdup > 1 INTO CURSOR dupcount>Is it not possible to use where clause on the count column.
Select crsprod, crsitemcode, sum(crsrequestamt) as inreq,; sum(crsaccptamt) as whsaccpt, Count(*) as cntdup; From crs_grid1 ; Group By crsprod, crsitemcode; HAVING cntdup > 1; INTO CURSOR dupcountor
Select crsprod, crsitemcode, sum(crsrequestamt) as inreq,; sum(crsaccptamt) as whsaccpt, Count(*) as cntdup; From crs_grid1 ; Group By crsprod, crsitemcode; HAVING COUNT(*) > 1; INTO CURSOR dupcount