Skip to content

Instantly share code, notes, and snippets.

@jongio

jongio/jongblogasaquery

Created June 4, 2016 18:56
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jongio/aa30af73d1e324ad1bb6fe27cbe181e7 to your computer and use it in GitHub Desktop.
Save jongio/aa30af73d1e324ad1bb6fe27cbe181e7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
jongblogasaquery
SELECT
position,
sum(count) as count
INTO
jongblogpowerbi
FROM
jongblogiothub
GROUP BY TumblingWindow(second, 1), position
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment