2016 Will be the Year Remembered as When Java Finally Had Window Functions! | Java, SQL and jOOQ.

2016 Will be the Year Remembered as When Java Finally Had Window Functions! | Java, SQL and jOOQ.

Java, SQL and jOOQ. Best Practices and Lessons Learned from Writing Awesome Java and SQL Code. Get some hands-on insight on what's behind developing jOOQ. 2016 Will be the Year Remembered as When Java Finally Had Window Functions! You heard right. Up until now, the awesome window functions were a feature uniquely reserved to SQL. Even sophisticated functional programming languages still seem to lack this beautiful functionality (correct me if I'm wrong, Haskell folks). We've written tons of blog posts about window functions, evangelising them to our audience, in articles like: | ID | VALUE_DATE | AMOUNT | |------|------------|--------| | 9997 | 2014-03-18 | 99.17 | | 9981 | 2014-03-16 | 71.44 | | 9979 | 2014-03-16 | -94.60 | | 9977 | 2014-03-16 | -6.96 | | 9971 | 2014-03-15 | -65.95 | … to this one, with a calculated balance: | ID | VALUE_DATE | AMOUNT | BALANCE | |------|------------|--------|----------| | 9997 | 2014-03-18 | 99.17 | 19985.81 | | 9981 | 2014-03-16 | 71.

Read full article from 2016 Will be the Year Remembered as When Java Finally Had Window Functions! | Java, SQL and jOOQ.