select sum(nvl2(DEL_DATE,0,1))/count(*) from a where to_char(input_date,'YYYYMMDD')>='20040101' and to_char(input_date,'YYYYMMDD')<='20040501'; 大概思想是这样的,没有调试过!
select sum(nvl2(DEL_DATE,0,1))/count(*) from a where to_char(input_date,'YYYYMMDD')>='20040101' and to_char(input_date,'YYYYMMDD')<='20040501'; 用这个试试
select sum(nvl(DEL_DATE,1))/count(*) from a where to_char(input_date,'YYYYMMDD')>='20040101' and to_char(input_date,'YYYYMMDD')<='20040501'; 用这个试试 不好意思刚才弄错了
用这个试试
用这个试试 不好意思刚才弄错了