difference between nvl(max(empno),0) and max(nvl(empno,0))
441475Jun 28 2005 — edited Jun 28 2005i have an empty table and iwant to select the max(empno)+1,so i write the following
select max(nvl(empno,0)+1 from emp;
the result was a null value
but
select nvl(max(empno),0)+1 from emp
the result was 1
i can not understand the differnce between the two sql statments.