[Info-ingres] FW: Which is the first Ingres release to support window functions?
Roy Hann
specially at processed.almost.meat
Wed Mar 21 14:42:40 UTC 2018
Alex Hanshaw wrote:
> Windowing functions in Ingres by release:
>
> Ingres 11.0
>
> * LEAD() and LAG()
> Ingres 10.2
>
> * RANK, DENSE_RANK, PERCENT_RANK, NTILE, and ROW_NUMBER.
Ah. That answers it Alex. I was trying to use lag() in 10.2. The error
message mislead me by complaining about OVER.
Thanks Alex.
Roy
More information about the Info-ingres
mailing list