17,086
社区成员
发帖
与我相关
我的任务
分享
WITH MET_OPS_REGNO AS(
SELECT '2014' YEAR,1 no,'001' ID FROM dual UNION ALL
SELECT '2014' YEAR,2 no,'002' ID FROM dual UNION ALL
SELECT '2014' YEAR,3 no,'003' ID FROM dual
)
SELECT NVL(MAX(NO), 0) + 1
FROM MET_OPS_REGNO
WHERE YEAR = TO_NUMBER(TO_CHAR(TO_DATE('2016-12-20 00:00:00',
'yyyy-MM-dd hh24:mi:ss'),
'yyyy'))
select nvl((select max(nvl(no, 0))
from MET_OPS_REGNO
where year = to_number(to_char(to_date('2014-12-20 00:00:00',
'yyyy-MM-dd hh24:mi:ss'),
'yyyy'))),
0) + 1
from dual
select nvl((select max(no)
from MET_OPS_REGNO
where year = to_number(to_char(to_date('2015-12-20 00:00:00',
'yyyy-MM-dd hh24:mi:ss'),
'yyyy'))),
0) + 1
from dual;