SDB101 » Select: Query 13
 
Query: List the countries with only one neighboring country. A country is a neighbor of another country if their land masses share a boundary. According to this definition, island countries, like Iceland, have no neighbors

SELECT Co.Name
FROM COUNTRY Co
WHERE Co.Name IN (
SELECT Co2.Name
FROM COUNTRY Co2, COUNTRY Co1
WHERE Touch(Co2.Shape,Co1.Shape)=1
GROUP BY Co2.Name
HAVING Count(*) = 1 )

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