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