Skip to main content
Inspiring
October 20, 2008
Question

DB help-select

  • October 20, 2008
  • 2 replies
  • 369 views
I am trying to graph number of males and females per year for a specific conditon...However my query doesnt work properly....Numbers shows on the wrong year....
For sample please visit nexium-vs-joints.com

loop
select start_yr,count(*) from table where gender ='#gen#' group by start_yr order by start_yr
End loop
This topic has been closed for replies.

2 replies

emmim44Author
Inspiring
October 21, 2008
That might help...thank you...
Inspiring
October 21, 2008
Don't know why you have a loop, but have you considered something like.

select start_yr, gender, count(*) thecount
from table
where something_maybe
group by start_yr, gender