Specify a WINDOW definition in the FROM clause that can be used multiple times in the SELECT list.

select id, 
       category,
       sum(value) over w,
       max(value) over w,
       count(*) over w
from the_table
window w as (partition by category)

Back to the SQL Feature Comparison