공부
[Athena] SQL COALESCE(a, 0) <-- NVL(a, 0)
승가비
2022. 6. 28. 02:35
728x90
https://stackoverflow.com/questions/43275356/presto-check-if-null-and-return-default-nvl-analog
Presto check if NULL and return default (NVL analog)
Is there any analog of NVL in Presto DB? I need to check if a field is NULL and return a default value. I solve this somehow like this: SELECT CASE WHEN my_field is null THEN 0 ELSE
stackoverflow.com
728x90