process management blog posts

How to calculate the longest and current consecutive streaks with Oracle SQL - #JoelKallmanDay

Blog: Oracle BPM

An explanation of how to find streaks - a consecutive series of events - using SQL pattern matching in Oracle Database. For example, the number of consecutive days users logged in, their winning streaks or they completed a task.