ORACLE中先ORDER BY又ROWNUM
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