擅长:python、mysql、java
<pre><code>Select f.FacilityID,
f.ZoneType,
m.MaxZoneDistance
from AllZones f
join (
SELECT max(ZoneDistance) MaxZoneDistance,
FacilityID
FROM AllZones
group by FacilityID
) m
on f.facilityID=m.facilityID
and MaxZoneDistance=ZoneDistance
</code></pre>
<p><strong>输出</strong></p>
<pre><code>FacilityID ZoneType MaxZoneDistance
1 B 2000
2 C 600
</code></pre>