SQL Server query without using cursor

Question

I have data in a table and need to populate the min and max range for the row number column.

This is my input table:

I would like to have the following output table result without using a cursor:

Gordon Linoff · Accepted Answer · 2020-02-20 19:25:32Z

3

Do you just want lag()?

select t.*,
       lag(rownumber, 1, 0) over (order by rownumber) as rownumber_min,
       rownumber as rownumber_max
from t;

answered Feb 20, 2020 at 19:25

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1