SQLTeam.com | Weblogs | Forums

Create a separate WINDOW clause and then reference it in each OVER

Hi all,

Is it possible to have a separate WINDOW clause and then reference it in each OVER

what I am trying to create.

SELECT
size
,max(price) over (partition by size) --- convert this
,max(price) over (xyz) --<to this
,min(price) over (xyz) --< to this
from products
window xyz as (partition by size) --< one separate window clause
order by size

No - you have to specify the window on each one.

thanks