maxInt

Determine maximum of two values (int format).

Compare two columns (int format) and return the higher value.

Usage Details

select *, maxInt(column1, column2) as maxValue from table

-- column1: first column
-- column2: second column

Updated 7 months ago