search

vertica / Vertica-Extension-Packages

User Defined Extensions (UDX) to the Vertica Analytic Database
http://www.vertica.com/
Other
119 stars 113 forks source link

Introduce NTH_VALUE Analytic Function #39

Open disq opened 9 years ago

disq commented 9 years ago

Usage: NTH_VALUE(expr, offset) OVER (...)

Like FIRST_VALUE or LAST_VALUE but for offset

sKwa commented 9 years ago

Hi!

How it differs from built-in function LEAD ( expression [, offset ] [, default ] ) OVER (...)? http://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/SQLReferenceManual/Functions/Analytic/LEADAnalytic.htm

disq commented 9 years ago

Looks like it doesn't.

CLAassistant commented 2 years ago

CLA assistant check
All committers have signed the CLA.