select id,name from ( select a.*,decode(rownum,1,1,2) rn from a ) order by rn,name
drop table t; create table t(id int,name varchar2(20)); insert into t values(1,'-'); insert into t values(2,'WANG'); insert into t values(3,'ZHANG'); insert into t values(4,'LI');select * from t order by decode(id,1,null,id) desc nulls first;
from (
select a.*,decode(rownum,1,1,2) rn
from a
)
order by rn,name
create table t(id int,name varchar2(20));
insert into t values(1,'-');
insert into t values(2,'WANG');
insert into t values(3,'ZHANG');
insert into t values(4,'LI');select * from t order by decode(id,1,null,id) desc nulls first;