SQL> select rownum,t1. * from t1 where rownum >0 order by name desc;
ROWNUM ID NAME
---------- ---------- --------------------
2 2 yourlove
7 6 xifenfei
5 8 ting
6 7 really
4 4 game
8 5 feng
3 3 eygle
1 1 about
已选择8行。
SQL> alter table t1 add constraint pkKey primary key(name);
表已更改。
SQL> select rownum,t1. * from t1 where rownum >0 order by name desc;
ROWNUM ID NAME
---------- ---------- --------------------
1 2 yourlove
2 6 xifenfei
3 8 ting
4 7 really
5 4 game