Retrieve & Compare number's store in table( database).
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 BangerPosted Nov 19, 2014, 12:00 AM
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 /...