ORACLE中先ORDER BY又ROWNUM

2012-08-17

ORACLE中先ORDER BY再ROWNUMselect t.*,t.rowid,rownum from test1 t where rownum3 order by CJ张三英语

ORACLE中先ORDER BY再ROWNUM

select t.*,t.rowid,rownum from test1 t where rownum<3 order by CJ

张三英语 75AAAHhOAALAAATSIAAC1
李四英语 78AAAHhOAALAAATSIAAF2

阅读人气排行