12c MATCH_RECOGNIZE and the 'start of group' method This is an off-site link.  Please review our Terms of Service for additional information.

(stewashton) Please don’t think this post is “just” about row pattern matching and MATCH_RECOGNIZE. I am going to present the “start of group” method as demonstrated by Timur Akhmadeev and Solomon Yakobson. This is a powerful use of analytics to group data based on comparisons between adjacent rows. It’s a technique worth knowing while waiting for 12c, when the MATCH_RECOGNIZE clause will make this much easier :)

Read this article...

comments powered by Disqus