SQL required to group by range . . .
Posted on 2004-04-21
I have the following working query:
select Count(CandidatetoJobID) as ThisCount,j.HourlyRate
from FSU_CandidatetoJob ctoj, FSU_Job j
where ctoj.JobID = j.jobID
group by j.HourlyRate
It returns one record for each unique hourly rate with a count of the number of jobs with that hourly rate in the ThisCount "field".
What I need is to be able to get the same query, but with one record for each RANGE of hourly rates. For example, first record should be for $5-$8/hr, second for $8.01 - $10/hr, third for $10.01 - $100/hr. Hourly rate is a decimal field, so ranges are 5-8, 8.01-10 and 10.01-100.
Any help appreciated!