Search posts...
SELECT ROUND(AVG(NVL(LENGTH, 10)), 2) AS AVERAGE_LENGTH FROM FISH_INFO;
SELECT ROUND(AVG(IFNULL(LENGTH, 10)), 2) AS AVERAGE_LENGTH FROM FISH_INFO;
NULL
NVL(인수1, 인수2)
IFNULL(인수1, 인수2)
stupefyee