请教各位,有一查询如下:
select W.CODE,W.NAME,W.Phone_Number,(sum(case substr(Z.RQ,1,10) when substr(sysdate-5,1,10) then XSJE else 0 end)) ,
(sum(case substr(Z.RQ,1,10) when substr(sysdate-4,1,10) then XSJE else 0 end)), .......有两计算列,我想让显示的列名是相应的日期,即substr(sysdate-5,1,10),怎么做呢?
select W.CODE,W.NAME,W.Phone_Number,(sum(case substr(Z.RQ,1,10) when substr(sysdate-5,1,10) then XSJE else 0 end)) ,
(sum(case substr(Z.RQ,1,10) when substr(sysdate-4,1,10) then XSJE else 0 end)), .......有两计算列,我想让显示的列名是相应的日期,即substr(sysdate-5,1,10),怎么做呢?
本来想试下select 1 as substr(sysdate-5, 1, 0) from dual;
结果不行.