Choosing Rows or Range

Question

Post reply

Choosing Rows or Range

Steve Jones - SSC Editor

SSC Guru

Points: 736212
More actions
May 31, 2021 at 12:00 am

#3875019

Comments posted to this topic are about the item Choosing Rows or Range

Viewing 4 posts - 1 through 3 (of 3 total)

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

Carlo Romagnano SSC-Insane Points: 22669 More actions · Answer 1

Please, post an example with RANGE!

I tried this one, so the right answer is PARTITION BY:

SELECT SUM(object_id)OVER()

,SUM(object_id)OVER(PARTITION BY NULL)

FROM sys.objects

WHERE object_id < 100

db-solutions@harbingergroup.com Grasshopper Points: 20 More actions · Answer 2

select sum(UnitPrice) over (partition by SalesOrderID) price, SalesOrderID from [Sales].[SalesOrderDetail]

and see below output for above query. output

Can you please share the query with Range?

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 3

The framing is the size of the window. The default is range. This is separate from the partitioning, which you can choose. Without an ORDER BY and without a framing, the default is either the entire range, or unbounded preceding to current row.