SELECT*FROM(SELECTROWNUMAS rowno, t.*FROM emp t
WHERE hire_date BETWEENTO_DATE('20060501','yyyymmdd')ANDTO_DATE('20060731','yyyymmdd')ANDROWNUM<=20) table_alias
WHERE table_alias.rowno >=10;
数组排序
int k[]={3,4,5,1,0,2};
Arrays.sort(k);for(int n=0;n<k.length;n++){
System.out.println(k[n]);}