Showing entries 1 to 1
Displaying posts with tag: window specification (reset)
Sep
20
2018
How to Reduce Syntactic Overhead Using the SQL WINDOW Clause
Posted by Lukas Eder on Thu 20 Sep 2018 11:50 UTC
Tags:

SQL is a verbose language, and one of the most verbose features are window functions. In a stack overflow question that I've encountered recently, someone asked to calculate the difference between the first and the last value in a time series for any given day: Input volume tstamp --------------------------- 29011 2012-12-28 09:00:00 28701 2012-12-28 10:00:00 … Continue reading How to Reduce Syntactic Overhead Using the SQL WINDOW Clause →

Showing entries 1 to 1