Advertisement
Guest User

Untitled

a guest
Mar 21st, 2019
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.07 KB | None | 0 0
  1. SELECT
  2. [npp].[Id]
  3. ,[npp].[PowerPlantName]
  4. ,[npp].[CountryName]
  5. ,[npp].[ReactorModel]
  6. ,[npp].Capacity
  7. ,Sum(npp.Capacity) OVER(PARTITION BY npp.CountryName ORDER BY npp.PowerPlantName) as RangeDefault
  8. ,Sum(npp.Capacity) OVER(PARTITION BY npp.CountryName ORDER BY npp.PowerPlantName RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as RangeDefault01
  9. ,Sum(npp.Capacity) OVER(PARTITION BY npp.CountryName ORDER BY npp.PowerPlantName RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as Range01
  10. ,Sum(npp.Capacity) OVER(PARTITION BY npp.CountryName ORDER BY npp.PowerPlantName RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) as Range02
  11. ,Sum(npp.Capacity) OVER(PARTITION BY npp.CountryName ORDER BY npp.PowerPlantName RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) as Range03
  12. ,Sum(npp.Capacity) OVER(PARTITION BY npp.CountryName ORDER BY npp.PowerPlantName RANGE CURRENT ROW) as Range04
  13. ,Sum(npp.Capacity) OVER(PARTITION BY npp.CountryName ORDER BY npp.PowerPlantName ROWS BETWEEN UNBOUNDED PRECEDING AND 1 FOLLOWING) as Rows01
  14. ,Sum(npp.Capacity) OVER(PARTITION BY npp.CountryName ORDER BY npp.PowerPlantName ROWS BETWEEN 2 PRECEDING AND UNBOUNDED FOLLOWING) as Rows02
  15. ,Sum(npp.Capacity) OVER(PARTITION BY npp.CountryName ORDER BY npp.PowerPlantName ROWS BETWEEN CURRENT ROW AND 3 FOLLOWING) as Rows03
  16. ,Sum(npp.Capacity) OVER(PARTITION BY npp.CountryName ORDER BY npp.PowerPlantName ROWS BETWEEN 2 PRECEDING AND 3 FOLLOWING) as Rows04
  17. ,FIRST_VALUE(npp.Capacity) OVER(PARTITION BY npp.CountryName ORDER BY npp.Capacity asc) as FFirstValue
  18. ,LAST_VALUE(npp.Capacity) OVER(PARTITION BY npp.CountryName ORDER BY npp.Capacity asc rows between unbounded preceding and unbounded following) as FLastValue
  19. ,MIN(npp.Capacity) OVER(PARTITION BY npp.CountryName) as FMin
  20. ,MAX(npp.Capacity) OVER(PARTITION BY npp.CountryName) as FMax
  21. ,LEAD(npp.Capacity) OVER(PARTITION BY npp.CountryName ORDER BY npp.PowerPlantName) as Lead01
  22. ,LAG(npp.Capacity) OVER(PARTITION BY npp.CountryName ORDER BY npp.PowerPlantName) as Lag01
  23.  
  24. FROM [Countries].[dbo].[NuclearPowerPlant] npp
  25. WHERE npp.Status = 'Operational'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement