I have a table with three integer columns:
select max(col1), max(col2), max(col3) from mytable
I want the max of both three columns. But this does not work:
select max(max(col1), max(col2), max(col3)) from mytable
How to get this done?
I use PostgreSQL, but I hope that this can be solved with standard SQL.