How to I update a row base on the lowest value of a particular column?
|1|X| <-- update X
What is the command to use?
I can do "select min(A) from table;" but not "update table set B=1 where min(A);".
Anyone expert in SQL language, please help!