select '1' 编号,'20121127' 日期,'2' 数值 from dual union all
select '2', '20121128','1' from dual union all
select '3', '20121129','3' from dual union all
select '4', '20121130','4' from dual union all
select '5', '20121130','3' from dual union all
select '6', '20121130','1' from dual union all
select '7', '20121130','2' from dual union all
select '8', '20121201','3' from dual union all
select '9', '20121201','2' from dual union all
select '10', '20121202','2' from dual union all
select '11', '20121203','2' from dual union all
select '12', '20121204&#
SQL codewith t1 as(select '1' 编号,'20121127' 日期,'2' 数值 from dual union allselect '2', '20121128','1' from dual union allselect '3', '20121129','3' from dual union allselect '4', '20121130','4' from ...
--参数月往前
推
11个月
SELECT TO_CHAR(ADD_MONTHS(TO_DATE('2021-12','yyyy-mm'),-11),'yyyy-mm') 月 FROM dual;
--
当前
月往前
推
11个月
SELECT TO_CHAR(ADD_MONTHS(SYSDATE,-11),'yyyy-mm') 月 FROM dual;
--参数月往后
推
11个月
SELECT TO_CHAR(ADD_MONTHS(TO_DATE('2021-12','yyyy-mm'),11),'yyyy-mm')
Base_station_record
WHERE
Basestation_info.element_name = Base_station_record.element_names
AND start_time >= DATE_SUB(DATE_SUB(curdate(),INTERVAL 1 DAY),INTERVA...
根据
当前
时间
获取最近5年
时间
：(yyyy)
SELECT to_char(SYSDATE,'YYYY') - LEVEL + 1 as "xAxisValue"
FROM dual
CONNECT BY LEVEL
ORDER BY to_char(SYSDATE,'YYYY') - LEVEL + 1 ASC
根据
当前
时间
获取最近6个月
时间
(yyyy-mm)：
SELECT
