Re:SQLite Release 3.25.0 adds support for window functions
by AlisdairO on Wednesday August 15, 2018 @12:08PM
(#17767135)
(self plug) try pgexercises.com. It's in a very similar vein to windowfunctions - I understand it was one of the original inspirations - but it covers a much wider range of material, with a gradual growth from very basic stuff up to slightly advanced.
[ Parent
| on HN ]
Re:SQLite Release 3.25.0 adds support for window functions
by mercer on Wednesday August 15, 2018 @01:42PM
(#17768028)
I'll vouch for this plug! I've spent quite a bit of time learning SQL (and Postgres specific stuff), and this was one of my favorite resources.
I can also recommend Learning SQL by Alan Beaulieu, which was recommended in some HN comment. After looking into various books, some of them Postgres specific, I found this one to be the best for learning from scratch.