Details

      Description

      ColumnStore and other database vendor implementations support a default parameter for the lead and lag window functions. The standard syntax is:
      LAG (value_expression [,offset] [,default])
      LEAD (value_expression [,offset] [,default])

      where the optional default is the value returned should the offset be outside of the window frame. If unspecified then NULL is used.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                dthompson David Thompson (Inactive)
              • Votes:
                4 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated: