SDB101 » Select: Query 6
 
Query: For each country in which at least two rivers originate, find the length of the smallest river

SELECT R.Origin, MIN(R.Length) AS Min-Length
FROM RIVER R
GROUP BY R.Origin
HAVING COUNT(*) >1

Query: List the countries whose GDP is greater that of Canada

SELECT Co.Name
FROM COUNTRY Co
WHERE Co.GDP > ANY(SELECT Co1.GDP
FROM Country Co1
WHERE Co1.Name = ‘Canada’)

Última modificación: Thursday, 17 de November de 2005, 17:25