select nvl(
(select min(rn) from(select rownum as rn, id from (select * from t_supplier_company_test t order by to_number(id))
) where rn <> id),
(select max(id) + 1 from t_supplier_company_test)
)
from dual
select rownum as rn, id from (select * from t_supplier_company_test t order by to_number(id))
) where rn <> id),
(select max(id) + 1 from t_supplier_company_test)
)
from dual
扫一扫
2431
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
