Created
October 12, 2022 21:56
-
-
Save J2112O/be4b4a71fd9ae3d30646e04d7753ccaa to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
id, start_segment, end_segment, | |
SUM(LAG(segment_length, 1) OVER(ORDER BY id ASC)) OVER(ORDER BY id ASC) AS one_lag | |
FROM coords_measure; | |
Error Code: 3593. You cannot use the window function 'lag' in this context. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment