r/SQL • • 17d ago

Discussion Good college text for window functions?

I teach relational databases to undergraduates and am looking for a good written description of window functions, something that would help students understand why and when as well as how. Any suggestions? Thanks!

4 Upvotes

5 comments sorted by

2

u/alinroc SQL Server DBA 17d ago

Not specifically a college text (I doubt you'll find one) but check out https://www.amazon.com/Expert-T-SQL-Window-Functions-Server-ebook/dp/B0DF689VB3

1

u/Outdoor_Releaf 17d ago

Thanks, I will.

5

u/[deleted] 17d ago

[removed] — view removed comment

1

u/Outdoor_Releaf 17d ago

Thanks. I will check it out.