我想要找到最大的列值,我说:Segment_ID.Segment_ID,Intensity.NumAll,MAX(Intensity.AverageDailyIntensCar) as maxvalue,FROM Segment_ID
LEFT JOIN Track ONSegment_ID.Segment_ID=Track.Segment</em
(*) over (partition by road_id) as [c]LEFT JOIN Segment_ID ON Road.Road_ID = Segment_ID.Road_IDLEFT JOIN Track ON Segment_ID.Segment_ID = Track.Segment_IDroads_by_segment as ( road_id[c]
from by_segment as