Re: Using Analytics......

Jonathan Lewis wrote:
>
> Moreover, if the OP had a data set that
> consisted of just one partition, then there
> would be no need for sorting in the window -
> although the distinct at the end could make
> that benefit vanish.
>

Thanks for clearing that up. The distinct was what made me sit up and take notice in the first place, it's one of those red flags for me, and I still don't feel comfortable enough with the "over" syntax to not expect it to always full table (or partition) scan. Appreciation to all who have posted analytics examples lately.

jg

--
@home.com is bogus.
"Taxpayers are mindful of the corporate accounting scandals, the
mutual fund scandals, big accounting firms and law firms concocting
sophisticated, illegal tax shelters for their big, wealthy clients.  I
think that is calling to people's mind their own sense of playing by
the rules and fair play, and paying what they owe under the tax laws...
It calls to mind an old adage: When they feel the heat, they'll see the
light." - Raymond Wagner Jr., Chairman, IRS Oversight Board