var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I have a database of a sports club. There's male and female members, males represented by a checked checkbox in the table.
Now i want to make a query that calculated the percentage of female members in the club.
select 'female pct: '
, sum( iif(malecheckbox=0, 1, 0) )
/ ( select count(*) from yourtable )
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors