How to Find the Longest Consecutive Series of Events in SQL | Java, SQL and jOOQ.

How to Find the Longest Consecutive Series of Events in SQL | 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. How to Find the Longest Consecutive Series of Events in SQL A very interesting problem that can be solved very easily with SQL is to find consecutive series of events in a time series. But what is a consecutive series of events in a time series? Take Stack Overflow, for example. Stack Overflow has a cool reputation system that uses badges to reward certain behaviour. As a social website, they encourage users to visit the platform every day. As such, two distinct badges are awarded: Informally, it is obvious what this means. You'll have to log in on day 1. Then again on day 2. Then again (perhaps several times, it doesn't matter) on day 3. Forgot to log in on day 4? Ooops. We'll start counting again. How to do this in SQL? On this blog, every problem will find its solution in SQL . So does this. And in order to solve this problem,

Read full article from How to Find the Longest Consecutive Series of Events in SQL | Java, SQL and jOOQ.