SDB101 » Select: Query 11
 
Query: List all countries, ordered by number of neighboring countries

SELECT Co.Name, Count(Co1.Name)
FROM COUNTRY Co, COUNTRY Co1
WHERE Touch(Co.Shape,Co1.Shape) =1
GROUP BY Co.Name
ORDER BY Count(Co1.Name)

Earlier version of OGIS did not provide spatial aggregate operation to support GIS operations like reclassify

Última modificación: Friday, 18 de November de 2005, 17:16