SELECT department, amount, salesmanager, -- DISTINCT(salesmanager), I tried using this line also... SUM(amount) OVER(PARTITION BY department, salesmanager) AS "Sum by dept.", ROW_NUMBER() OVER() AS "row number", ROUND((amount/SUM(amount) OVER(PARTITION BY department, salesmanager)) * 100) AS "% of total" FROM sales -- GROUP BY department, salesmanager ORDER BY department, salesmanager
Not Test.
You just want these rows returned, right?
SELECT department, salesmanager
FROM sales
GROUP BY department, salesmanager
Along with some calculations:
SELECT *, total_mgr_dept / total_dept_only AS manager_share_of_department
FROM (
SELECT department, salesmanager,
sum(amount)::numeric AS total_mgr_dept,
(sum( sum(amount) ) OVER (PARTITION BY department))::numeric AS total_dept_only,