var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Can I get an N count while using Perentile_Cont
SELECT jobcode, PERCENTILE_CONT(0.5)
WITHIN GROUP (ORDER BY salary DESC) MEDIAN_CONT
GROUP BY jobcode;
I have a query where I am calulating percentile salary for employees with the same jobcode.
The percentiles are great, but I also need to know the number of employees by jobcode within the same statement.
So for example, the query above returns
But I would also like a N count of employees.
Answered my own question. I did not think added COUNT to the query would actually work and not break my groupings. Brain freeze....