calculate percentage with group by

Question

I've tried a few ways n not got it I know it's just getting the wording in the right places; it should be easy cos I know how you work out percentages... I'm just struggling to put it down as a query in SQL .

9 people 5 female ,4 male

SELECT sex, count(*),count(*)*100/ count(title)/100.0 as percentage
  FROM details
 GROUP BY sex;

Answer 1

Here is one way to do this using analytic functions:

SELECT sex, COUNT(*), 100.0 * COUNT(*) / SUM(COUNT(*)) OVER () AS percentage
FROM details
GROUP BY sex;