Get min record value below each record in a column

[jharaldson]

I would like a query to get the min record value below each record in a column and put the value in a column for itself, example output would be the Min column



Name Score Min
John 95 80
Tim 100 80
Eric 80

[drunkenneo]

If u already have table probably the code will be...

Update table set min = min(score) where score> min(score)

[jharaldson]

select name, score,(select min(score)
from
(select name, score
from
scores)) as min
from
scores;

this is what i have and it gives me the lowest score overall in the min column, i need the lowest score below the current row

thanks