New answers tagged


Assuming that your DBMS supports window functions: select t, v , (v-min(v) over ()) / (max(v) over () - min(v) over ()) from t if your DBMS don't support window functions you can use sub-selects: select t,v , (v - (select min(v) from t)) / (select max(v) - min(v) from t) from t I used the following ...

Top 50 recent answers are included