I have a Mysql table like below in Mysql
1000 2000 2000 3000 3000 4000 4000 5000
I want to scale one of the column and show values between 0-10.
I tried but couldn't succeed. I want to do something like below
scaledValue = (rawValue - min) / (max - min);
Anyone knows a query to help ?
Thanks in adavance