Retrieve & Compare number's store in table( database).

Question

I want to compare three numbers(integer) from three different column of one table & by finding minimum number calculating avg of remaining  two numbers(greater) then store that avg in another column. How I can retrieve number store in table & compare it row-wise?Whats the logic for accessing store record & calculate avg of best  two no...???