Allegra Term / Sold Herds As of: 2019.06.08 22:37 Reported Termination Date - when termination was done COUNT(1) PR TDATE Status --------- -- ------------ ----------- 1 02 01-MAY-19 Sold 21 04 01-MAY-19 Sold 2 05 01-MAY-19 Sold COUNT(1) PR TDATE Status --------- -- ------------ ----------- 22 04 01-MAY-19 Term 5 05 01-MAY-19 Term group by hrd.prv_cd, * ERROR at line 15: ORA-01787: only one clause allowed per query block