--Looking At Total Population vs Vaccinations
SELECT dea.continent, dea.location, dea.population, dea.Date
, vac.new_vaccinations
, SUM(CAST(vac.new_vaccinations AS int)) OVER (Partition BY dea.location ORDER BY dea.location, dea.Date) AS RollingPopVaccinated
FROM PortfolioProject..CovidDeaths dea
JOIN PortfolioProject..CovidVaccination vac
ON dea.location = vac.location
AND dea.Date = vac.Date
WHERE dea.continent IS NOT NULL
輸出：
訊息 8115，級別 16，狀態 2，第 70 行將運算式轉換為資料型別 int 的算術溢位錯誤。警告：空值被聚合或其他 SET 操作消除。
uj5u.com熱心網友回復：
嘗試轉換new_vaccinations為bigint而不是常規int：
SELECT dea.continent, dea.location, dea.population, dea.Date, vac.new_vaccinations,
SUM(CAST(vac.new_vaccinations AS bigint)) OVER (PARTITION BY dea.location
ORDER BY dea.location, dea.Date) AS RollingPopVaccinated
FROM PortfolioProject..CovidDeaths dea
INNER JOIN PortfolioProject..CovidVaccination vac
ON dea.location = vac.location AND dea.Date = vac.Date
WHERE dea.continent IS NOT NULL;
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/456569.html
上一篇：根據型別獲取記錄Z-Score