David Rowley wrote:
> It's not 100% certain that it will be possible for 8.4, probably though.
>
> select row_number() over (order by employeeid) as nrow,* from employee order
> by employeeid
That makes sense, thanks. So extracting rate-of-change etc. would be a
join on two subselects followed by a bit of maths, that's likely to be a
big incentive for an upgrade when it comes out.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]