Spatial Databases 101

CREATE VIEW Neighbor AS
SELECT Co.Name, Count(Co1.Name) AS num_neighbors
FROM COUNTRY Co, COUNTRY Co1
WHERE Touch(Co.Shape,Co1.Shape)=1
GROUP BY Co.Name

SELECT Co.Name,num_neighbors
FROM NEIGHBOR
WHERE num_neighbor = (

SELECT MAX(num_neighbors)
FROM NEIGHBOR )

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