Window function (SQL): Difference between revisions

Content deleted Content added
m fix syntaxhighlight error
m Example: lang="psql"
Line 61:
Ophelia|
Zach| <-- Following (unbounded)
In the above table, the next query extracts for each row the values of a window with one preceding and one following row:<syntaxhighlight lang="sqlpsql">
SELECT
LAG(name, 1)