INCREMENT BY参数可以实现
升序:
CREATE SEQUENCE customers_seq START WITH 1 INCREMENT BY 1;
降序:
CREATE SEQUENCE customers_seq START WITH 1000000000 INCREMENT BY -1;
举个例子吧
select * from emp t order by t.empno desc 降序
select * from emp t order by t.empno asc 升序