Re:Window Functions in SQL (2013)
by lukaseder on Friday October 07, 2016 @04:55AM
(#12659121)
Yes, it's a band-aid. But perhaps it will feel less so, if you're looking at the original invention by Esper Tech (I have no experience with it, just know that I've seen MATCH_RECOGNIZE there first):
http://www.espertech.com/esper/release-5.1.0/esper-reference...
Hah, yeah CONNECT BY is great for simple recursion, but for more complex (probably less performing) cases, I prefer the standard approach with CTEs...
Hah, yeah CONNECT BY is great for simple recursion, but for more complex (probably less performing) cases, I prefer the standard approach with CTEs...