SQL Window Functions

Re:SQL Window Functions by zzo38computer on Wednesday September 04, 2019 @12:16AM (#20873951)

I have used window functions in SQLite. You don't need it a lot, but there are some uses for it. However, I don't know what the EXCLUDE clause is good for; it doesn't seems so useful.

[ Parent | on HN ]

Re:SQL Window Functions by linkerzx on Wednesday September 04, 2019 @05:10AM (#20875330)

Yeah the addition of window functions onto sqlite last year was quite a good feature to enable more data use cases with sqlite.

The exclude clause is part of the "window" configuration which defines which row to process, with it you can for instance define a range between all the previous and next rows and check if your data-point looks abnormal.

[ Parent | on HN ]