August 18, 2023 at 9:34 am
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
August 18, 2023 at 6:59 pm
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.
August 22, 2023 at 1:17 am
This was removed by the editor as SPAM
September 1, 2023 at 1:23 pm
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply