May 6, 2024

[Tips] Database NULL to Zero

Oracle SELECT NVL(col, 0 ) FROM mytable
SQL Server SELECT ISNULL(col, 0 ) FROM mytable
MySQL SELECT IFNULL(col, 0) AS column_name FROM mytable

0 comments: