Hail,
I have 4 fields: tName, tDate, tTime, TotalUtilizationAvg (this field in in %)
What I need is to get the max amount from the Utilization field per day per Name which I do like so:
SELECT tName, tDate, max(TotalUtilizationAvg) as MaxUtil
FROM Traffic
GROUP BY BridgeName, TrafficDate
This works great, now I need to know the time at which this MaxUtil was hit (it's in increments of 15 minutes and if it was reached multiple times just need the first one) and if I add the time into the query with the group by, it'll just give me the MaxUtil field for every time of the day...
I'm assuming there's a way to display the time field in this situation but can't figure it out
I have 4 fields: tName, tDate, tTime, TotalUtilizationAvg (this field in in %)
What I need is to get the max amount from the Utilization field per day per Name which I do like so:
SELECT tName, tDate, max(TotalUtilizationAvg) as MaxUtil
FROM Traffic
GROUP BY BridgeName, TrafficDate
This works great, now I need to know the time at which this MaxUtil was hit (it's in increments of 15 minutes and if it was reached multiple times just need the first one) and if I add the time into the query with the group by, it'll just give me the MaxUtil field for every time of the day...
I'm assuming there's a way to display the time field in this situation but can't figure it out