Re: DB2 SQL window functions

[rick baird <rick.baird@xxxxxxxxx>]

count is available on db2400 but I don't see over().  what's it supposed to do?

re. the error message, your problem may be that you're using a summary
function (count) without a summary query.

try

select suit, weight, count(*)
from cpayne.window
group by suit, weight
order by suit, weight


On 2/6/06, Chris Payne <CPayne@xxxxxxxxxxxxxxx> wrote:
> I recently purchased the SQL cookbook from oreilly, and one of the
> topics is something called "window functions". According to the book
> this is one of a whole group of analytical functions that was added in
> the SQL - 99 standard. I tried to run the very simple query:
>
>
>
> SELECT
>
> SUIT,
>
> WEIGHT,
>
> count(*) over()
>
> FROM
>
> cpayne.window
>
>
>
> and got the response:
>
>
>
> Token ( was not valid. Valid tokens: , FROM INTO.
>
>
>
> Does anyone know about these window functions? Have they been
> implemented in DB2/400?
>
> ___________________________________
> Christopher Payne
> CPayne@xxxxxxxxxxxxxxx
> System Administrator/Programmer
>
>
>
> The Crown Group
> Corporate Offices
> 2111 Walter Reuther Drive
> Warren, MI 48091-6199
>
>
>
> Phone: (586) 575-9800
> Direct: (586) 558-5317
> Fax:  (586) 575-9856
>
>
>
>
>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>