I have a database where I record the results for competitors of Triathlons.
TotalTime
SwimTime
BikeTime
RunTime
etc etc etc
I need to get their positions both overall as well as for the swim, Bike and Run, using the COUNT function. Do I have to do a seperate query for each discipline or is there a way of combining the 4 queries within one?
TotalTime
SwimTime
BikeTime
RunTime
etc etc etc
I need to get their positions both overall as well as for the swim, Bike and Run, using the COUNT function. Do I have to do a seperate query for each discipline or is there a way of combining the 4 queries within one?