select DISTINCT
(select * from FUND_PERFORMANCE_DATA WHERE TO_DATE(NAVLATESTDATE, 'DD-MON-RR') = TO_DATE(add_months(sysdate),'DD-MON-RR')) AS 1DayData,
(select * from FUND_PERFORMANCE_DATA WHERE TO_DATE(NAVLATESTDATE, 'DD-MON-RR') >= TO_DATE(add_months(sysdate,-1),'DD-MON-RR')) AS 1MonData,
(select * from FUND_PERFORMANCE_DATA WHERE TO_DATE(NAVLATESTDATE, 'DD-MON-RR') >= TO_DATE(add_months(sysdate,-3),'DD-MON-RR')) AS 3MonData,
(select * from FUND_PERFORMANCE_DATA WHERE TO_DATE(NAVLATESTDATE, 'DD-MON-RR') >= TO_DATE(add_months(sysdate,-6),'DD-MON-RR')) AS 6MonData,
(select * from FUND_PERFORMANCE_DATA WHERE TO_DATE(NAVLATESTDATE, 'DD-MON-RR') >= TO_DATE(add_months(sysdate,-12),'DD-MON-RR')) AS 1YearData,
(select * from FUND_PERFORMANCE_DATA WHERE TO_DATE(NAVLATESTDATE, 'DD-MON-RR') >= TO_DATE(add_months(sysdate,-36),'DD-MON-RR')) AS 3YearData,
(select * from FUND_PERFORMANCE_DATA WHERE TO_DATE(NAVLATESTDATE, 'DD-MON-RR') < TO_DATE(add_months(sysdate),'DD-MON-RR')) AS AllData
from FUND_PERFORMANCE_DATA
代码运行时提示为参数个数无效,萌新看不懂错在哪了
额...我知道了...