I'm working on a Web-based poll where, among other things, you fill in your gender (m,f). I would like to construct an SQL query that calculates the fractions of males and females in my table. The following returns the absolute number of people of each gender but having it in fractions is something I don't know how to do.
SELECT gender, Count(*) AS Number FROM mytable GROUP BY gender;
Dig Deeper on Oracle and SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.