Re: sum of a column (development question)

Perhaps I am mistaken. use of analytic functions will leave the developer with a way forward if/when the requirements change (two years, three years, by quarter, whatever) and prevent the need to recode. In addition, the exercise strengthens the developer's ability with analytic functions.

It's only a suggestion ...

r,

Gus

On Sep 12, 2007, at 8:51 AM, Andrew Kerber wrote:

> You lost me on that one. How would ntile apply when he just wants
> totals for this year and last year?
>
> On 9/11/07, August Spier < gspier_at_chiliad.com> wrote:
> I was under the impression that NTILE would be more useful ...
> especially if you are in a development cycle and requirements for
> more sql statements are going to surface.
>
> See http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/
> functions101.htm#sthref1696
>
> r,
>
> Gus
>

--
http://www.freelists.org/webpage/oracle-l