not single-group grouping function while using regr_slope
Posted
by Peter Kaleta
on Stack Overflow
See other posts from Stack Overflow
or by Peter Kaleta
Published on 2010-06-13T23:24:05Z
Indexed on
2010/06/13
23:32 UTC
Read the original article
Hit count: 258
HI I try to run :
select
year,
regr_slope(sum(sale_count),year) as slope,
from products
group by year
It throws "00937. 00000 - "not a single-group group function"" .When i delete year from select clause problem disapears. Shouldn't I be able to select column with which I'm grouping?
Oracle 11.2 sqldeveloper
ty for help !
© Stack Overflow or respective owner
