Let me ask, how often is this data updated?
Your best bet might be to take a different approach from a simple
select. You may want to pre-aggregate the data somehow before it is
queried, for instance by creating a table to contain this information
and updating it once an hour. You could even take
Steven,
Try this if your DBMS is SQL Server:
select str((select sum(num_emp)/sum(num_jobs) from test3 where
month(test_date)=1),5,1) as jan_rate, str((select sum(num_emp)/sum(num_jobs)
from test3 where month(test_date)=2),5,1) as feb_rate...
You get the idea. BTW, any jobs up your way? I'm
2 matches
Mail list logo