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...???

Joginder Banger · Answer

hi vasudha I understand what's you try. first of all you need a temporary table for hold the value. after hold the value you need a create a function get the min value and again create function avg for left two value. I can't understand you want every thing insert time or all ready you have data in table. reply /...