oracle 序列中升序和降序

2025-03-25 13:37:15
推荐回答(2个)
回答1:

INCREMENT BY参数可以实现
升序:
CREATE SEQUENCE customers_seq START WITH 1 INCREMENT BY 1;

降序:
CREATE SEQUENCE customers_seq START WITH 1000000000 INCREMENT BY -1;

回答2:

举个例子吧
select * from emp t order by t.empno desc 降序
select * from emp t order by t.empno asc 升序