-- returns the greatest value, in case 1 select greatest( 0, 1 ) -> 1 -- it also works with null values select greatest( null, 1 ) -> 1