WINDOW RANGE funtion user input?

Question

Post reply

WINDOW RANGE funtion user input?

kirti

Old Hand

Points: 387
More actions
May 16, 2019 at 7:18 am

#3644105

Can RANGE window function take user input as value for interval and ranges instead of unbounded preceding and current row?

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

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

drew.allen SSC Guru Points: 77014 More actions · Answer 1

It's simple enough to test. Have you done so?

Drew

J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

Steve Jones - SSC Editor SSC Guru Points: 738643 More actions · Answer 2

OVER clause: https://docs.microsoft.com/en-us/sql/t-sql/queries/select-over-clause-transact-sql?view=sql-server-2017

If you mean something like this, you can't do this:

declare @i int = 2;
select sum(a) over (partition by b
                    order by c
                    rows between current row and @i following
                    )
 from mytable

Phil Parkin SSC Guru Points: 247180 More actions · Answer 3

kirti wrote:

Can RANGE window function take user input as value for interval and ranges instead of unbounded preceding and current row?

What do you mean by "user input"? What client application are you using?