Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- [npp].[Id]
- ,[npp].[PowerPlantName]
- ,[npp].[CountryName]
- ,[npp].[ReactorModel]
- ,[npp].Capacity
- ,Sum(npp.Capacity) OVER(PARTITION BY npp.CountryName ORDER BY npp.PowerPlantName) as RangeDefault
- ,Sum(npp.Capacity) OVER(PARTITION BY npp.CountryName ORDER BY npp.PowerPlantName RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as RangeDefault01
- ,Sum(npp.Capacity) OVER(PARTITION BY npp.CountryName ORDER BY npp.PowerPlantName RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as Range01
- ,Sum(npp.Capacity) OVER(PARTITION BY npp.CountryName ORDER BY npp.PowerPlantName RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) as Range02
- ,Sum(npp.Capacity) OVER(PARTITION BY npp.CountryName ORDER BY npp.PowerPlantName RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) as Range03
- ,Sum(npp.Capacity) OVER(PARTITION BY npp.CountryName ORDER BY npp.PowerPlantName RANGE CURRENT ROW) as Range04
- ,Sum(npp.Capacity) OVER(PARTITION BY npp.CountryName ORDER BY npp.PowerPlantName ROWS BETWEEN UNBOUNDED PRECEDING AND 1 FOLLOWING) as Rows01
- ,Sum(npp.Capacity) OVER(PARTITION BY npp.CountryName ORDER BY npp.PowerPlantName ROWS BETWEEN 2 PRECEDING AND UNBOUNDED FOLLOWING) as Rows02
- ,Sum(npp.Capacity) OVER(PARTITION BY npp.CountryName ORDER BY npp.PowerPlantName ROWS BETWEEN CURRENT ROW AND 3 FOLLOWING) as Rows03
- ,Sum(npp.Capacity) OVER(PARTITION BY npp.CountryName ORDER BY npp.PowerPlantName ROWS BETWEEN 2 PRECEDING AND 3 FOLLOWING) as Rows04
- ,FIRST_VALUE(npp.Capacity) OVER(PARTITION BY npp.CountryName ORDER BY npp.Capacity asc) as FFirstValue
- ,LAST_VALUE(npp.Capacity) OVER(PARTITION BY npp.CountryName ORDER BY npp.Capacity asc rows between unbounded preceding and unbounded following) as FLastValue
- ,MIN(npp.Capacity) OVER(PARTITION BY npp.CountryName) as FMin
- ,MAX(npp.Capacity) OVER(PARTITION BY npp.CountryName) as FMax
- ,LEAD(npp.Capacity) OVER(PARTITION BY npp.CountryName ORDER BY npp.PowerPlantName) as Lead01
- ,LAG(npp.Capacity) OVER(PARTITION BY npp.CountryName ORDER BY npp.PowerPlantName) as Lag01
- FROM [Countries].[dbo].[NuclearPowerPlant] npp
- WHERE npp.Status = 'Operational'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement