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@xxxxxxxxxxx> 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#sthref1696r, Gus