Skip to content

Instantly share code, notes, and snippets.

@vendethiel

vendethiel/advanced-sql-stuff

Created February 14, 2018 15:29
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 vendethiel/1de9a36b52e671a45e724e3c754c905b to your computer and use it in GitHub Desktop.
Save vendethiel/1de9a36b52e671a45e724e3c754c905b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
advanced-sql-stuff
Advanced SQL
<https://www.slideshare.net/MarkusWinand/modern-sql?ref=https://modern-sql.com/slides>
slide 3: `LATERAL`
slide 12: `GROUPING SETS`
slide 19: `WITH`
slide 45: `WITH RECURSIVE`
slide 71: `FILTER`
slide 75: `PARTITION BY`, `OVER` (/`OVER ORDER BY`)
slide 105: `WITHIN GROUP`
slide 113: `TABLESAMPLE`
slide 116: `FETCH FIRST`
slide 135: `LEAD`, `LAG`, `NTH_VALUE`… in `OVER`
slide 137: Temporal Tables
slide 148: `MATCH_RECOGNIZE`
slide 165: `LIST_AGG`
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment