3,491
社区成员
发帖
与我相关
我的任务
分享
SQL>
SQL> create table aaa(
2 did number(2),
3 dname varchar2(10)
4 );
Table created
SQL> begin
2 insert into aaa values(1,'admin');
3 insert into aaa values(2,'super user');
4 insert into aaa values(3,'user');
5 insert into aaa values(4,'user');
6 insert into aaa values(5,'super user');
7 insert into aaa values(6,'user');
8 insert into aaa values(7,'admin');
9 end ;
10 /
PL/SQL procedure successfully completed
SQL> select * from aaa
2 order by decode(dname,'admin',1,'user',2,'super user',3) , did ;
DID DNAME
--- ----------
1 admin
7 admin
3 user
4 user
6 user
2 super user
5 super user
7 rows selected
SQL> drop table aaa ;
Table dropped
SQL>
select * from t order by 用户类型, id