How can I compare column value inside COUNT() function?
864626Jul 11 2011 — edited Jul 11 2011I want to compare column value inside COUNT() function like below how ever it gives me error. I want to compute percentage, how can I do this task?
Thanks.
SELECT department_id
, COUNT(salary < 250000) / COUNT(*)
FROM plch_employees
GROUP BY department_id
ORDER BY department_id;