Greatest
06/08/2023 11:20
It takes the greatest column value:
greatest(o._fivetran_synced, nvl(ox._fivetran_synced, '1900-01-01'), nvl(ea._fivetran_synced, '1900-01-01'), nvl(eax._fivetran_synced, '1900-01-01'),nvl(oxm._fivetran_synced, '1900-01-01')) AS LAST_UPD