Skip to content

Instantly share code, notes, and snippets.

@smalik

smalik/mad.sql

Created September 27, 2018 21:17
Show Gist options
  • Save smalik/b8a9b26a3e4b9dfdd4c3a1b5a51c565a to your computer and use it in GitHub Desktop.
Save smalik/b8a9b26a3e4b9dfdd4c3a1b5a51c565a to your computer and use it in GitHub Desktop.
Download ZIP
SQL Code for mean absolute deviation
Raw
mad.sql
SELECT id, MEDIAN(ABS(value - med))
FROM (
SELECT id, value, MEDIAN(value) OVER(PARTITION BY id) AS med
FROM mytable
)
GROUP BY
id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment