how new window clause works in following case.

Question

how new window clause works in following case.

rajemessage 14195

Hall of Fame

Points: 3339
More actions
August 18, 2023 at 9:34 am

#4264410

hi,
can i get one example of following from this link
https://learn.microsoft.com/en-us/sql/t-sql/queries/select-window-transact-sql?view=sql-server-ver16
"If the <window_expression> is contained in a <query_specification> that is part of <query_expression> which is a simple table query, then the scope of the new window_name also includes the <order_by_expression>, if any, of that <query_expression>."

yours sincerley

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 738850 More actions · Answer 1

I'm not sure what you want here. There are examples on that page. The top has a TOC with links, like this one for examples: https://learn.microsoft.com/en-us/sql/t-sql/queries/select-window-transact-sql?view=sql-server-ver16#examples

This was added to make it easier to re-use a window in multiple aggregates in a query. This is instead of repeating the OVER() clause for all the various items in the SELECT clause.