I have a query which selects a max value over all the values of in a datetime column (dtimesent).
select dtimesent, max(ResponseTime) AS maxtime FROM allrequests where Request like '%Requestsa%' group by dtimesent
I need to get the value of the request colmn for each max response time in each group by. Is there any easy way to do this? There can be multiple rows per dtimesent value so I can't just include the request column in the group by,