SELECT land, continent, gpd, population ,area
FROM
(
SELECT *,
COUNT(CASE WHEN gdp IS NULL THEN 1 ELSE NULL END) OVER (PARTITION BY continent) AS gdpcnt
FROM world
)t
WHERE gdpcnt=0
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Help with this problem sql
Posted - 02/01/2013 : 05:12:00
