Flashin Leather: Second Top of Stack

nospam@example.com (Flashin Leather) — Sat, 18 Jul 2009 21:55:14 -0700

Thanks for the tip! I'll check it out.

PeopleSoft Tipster: Second Top of Stack

nospam@example.com (PeopleSoft Tipster) — Sat, 18 Jul 2009 16:08:19 -0700

If you find that you're having to find rows prior to the current one frequently you may want to have a look at the LAG analytic function. It only works on Oracle (but looking at your SQL it appears that's what you are using).

There's a starter-for-10 post on it here:
http://peoplesofttipster.com/2007/09/21/lag-and-lead/

It also handles situations where the second row has the same effdt as the current row (but a lower effseq).

Flashin Leather - Comments

Flashin Leather: Second Top of Stack

PeopleSoft Tipster: Second Top of Stack