Question

If it is possible, how to select the value of the largest numerical field of the same record / row (as opposed to the largest value in the same column). Something like select id, max (f1,f2,f3,f4) as f from table; Where f would give the largest number of those four fields ... This is just an example what Id like to have it actually does not work.

Answer 1

Im looking for an SQL statement as a solution, I have a solution in a spreadsheet program.

Answer 2

This does the job

Select max(val)
From
(
Select max(f1) as val FROM table
union
Select max(f2) as val FROM table
union
Select max(f3) as val FROM table
union
Select max(f4) as val FROM table
) subquery