вот запрос выдает ошибку
SELECT
nvl(tp ,' Итого') tp
, nvl(agnabbr ,' Итого') agnabbr
, nvl(grp_category ,' Итого') grp_category
, nvl(GROUP_NAME ,' Итого') GROUP_NAME
, nvl(GRP_CATEGORY_BREND,' Итого') GRP_CATEGORY_BREND
, nvl(NOMEN_NAME ,' Итого') NOMEN_NAME
,count (DISTINCT agnfifo) TT
,SUM(sdal) sdal
,SUM(dal_C) dal_C
,SUM(dal_C_s) dal_C_s
,count (DISTINCT agnfifo_1) TT_D
,SUM(sdal_1) sdal_D
,SUM(dal_C_1) dal_C_D
,SUM(dal_C_s_1) dal_C_s_D
from V_VICSO_SALE_OTDO
GROUP BY rollup(
tp
, agnabbr )
, rollup(grp_category
, GROUP_NAME
, GRP_CATEGORY_BREND
, NOMEN_NAME)
а так все работает
GROUP BY rollup(
tp
, agnabbr
, grp_category
, GROUP_NAME
, GRP_CATEGORY_BREND
, NOMEN_NAME)
ошибка
ORA-00604: error occurred at recursive SQL level 1
ORA-00918: column ambiguously defined