Report 0 event if Empty set was received by SQL select

On Oracle and MariaDB 10.2

SELECT NVL(MIN(value),'0') FROM history WHERE itemid = '980627';

On PostgresSQL 10:

SELECT COALESCE(MIN(value),'0') FROM history WHERE itemid = '980627';