Well, it's not quite as simple as you seem to suggest...
SELECT OriginID, DestinationID, Total_feet FROM distanceCOSTTABLE WHERE (Total_feet = (SELECT MAX(Total_feet) AS Expr1 FROM distanceCOSTTABLE AS f WHERE (f.OriginID = distanceCOSTTABLE.originid))) ORDER BY total_feet
Signed in members can post, follow updates, and more. New here? Register a free account.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.