Skip to content

Instantly share code, notes, and snippets.

@harisankarh

harisankarh/7.sql

Created March 12, 2018 16:22
Show Gist options
  • Save harisankarh/4ed871ef97e002e4ac708e467ba17727 to your computer and use it in GitHub Desktop.
Save harisankarh/4ed871ef97e002e4ac708e467ba17727 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
7.sql
SELECT *,
SUM(x1*dhidden_0) OVER () AS dw_00,
SUM(x1*dhidden_1) OVER () AS dw_01,
SUM(x2*dhidden_0) OVER () AS dw_10,
SUM(x2*dhidden_1) OVER () AS dw_11,
SUM(dhidden_0) OVER () AS db_0,
SUM(dhidden_1) OVER () AS db_1
FROM {inner subquery}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment