Answer the question
In order to leave comments, you need to log in
The ORDER BY list of the RANGE window frame has a total size of 1020 bytes. The maximum supported size is 900 bytes. How to complete a request?
For this request
select death.location, death.continent, death.date, death.population, vacs.new_vaccinations
, SUM(CONVERT(int,vacs.new_vaccinations)) OVER (Partition by death.Location Order by death.location, death.Date) as RollingPeopleVaccinated
--, (RollingPeopleVaccinated/population)*100
from PortfolioCovid.dbo.Deaths death
Join PortfolioCovid.dbo.Vaccinations vacs
on death.location = vacs.location
and death.date = vacs.date
where death.continent is not null
Список ORDER BY оконной рамки RANGE имеет общий размер 1020 байт. Максимально поддерживаемый размер равен 900 байт.
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question