oracle SQL查询经验总结

1、oracle伪列 rowNUM

     select * from(select rownum no,*  from table) where no>2 and no<3;     select * from(select rownum