Paul Linehan schrieb am 10.05.2016 um 15:22:
> in order to improve my analytic/window function skills, I went
> here (http://www.postgresql.org/docs/current/static/tutorial-window.html).
>
> Now, there appears to be some sort of sample data (empsalary), but
> I can't find the necessary table(s) for this.
>
> Is there somewhere I can get this data? I did Google "PostgreSQL
> sample database" but no joy.
See the Postgres Wiki:
https://wiki.postgresql.org/wiki/Sample_Databases
> Finally, can anyone recommend any good site(s) for Analytic/Window
> functions - preferably with sample tables - personally, I find it much
> easier to relate to a concept if I can a) "eyeball" the data, and b)
> experiment further with my own queries/ideas.
The presention "Modern SQL" is worthwhile going through:
http://modern-sql.com/slides
Window functions start at slide 65
Thomas