This article teaches you how to get the biggest value in the columns in the same table.
It could be done by the built-in function GREATEST
However, it does not work when there are null values in the column.
You may use NVL function as a work around.