Comments for FIRST_VALUE and LAST_VALUE Analytic Functions
msq said...Shouldn't be IGNORE NULLS inside the first brackets rather..?
LAST_VALUE(sal IGNORE NULLS)
LAST_VALUE(sal) IGNORE NULLS
No. Mine is correct. This is the ANSI version. Oracle, supports both, with the same result, but the method you suggest is non-ANSI and deprecated. See:
msq said...I got ora-30484 running your version, but now checked again - it was some ancient dev db running 10g so it makes sense. Thank you.
Don said...Easy to follow example for last_value(). Thanks.
Randy said...Very much appreciated, thank you.