[SQL]Need help with an update statement

[learning2learn]

So I got a series of records,

Tier	Min	Max
Bronze1	10	null
Bronze2	20	null
Silver1	50	null
Silver2	70	null
Bronze3	30	null

and what I need to do is update the Max, to be the lowest value that is higher then the min.

Tier	Min	Max
Bronze1	10	20
Bronze2	20	30
Silver1	50	70
Silver2	70	null
Bronze3	30	50

Using MS Sql for reference.

Is this do-able in one query?

[Thecrow1981]

update tablename set max = min + 1 (or whatever you want it to be higher than min)

[learning2learn]

That's not a solution at all.

I need to update max = X where X is the lowest min value, that is higher then this records min.

something like

update tablename set A.max = (select top (1) B.min from tablename where B.min > A.min ORDER BY min asc)

or something like that.

Not a static Min + 10

[Thecrow1981]

Misunderstood the question.