Smartly_Yan的博客

Oracle：select * from (select rownum as num,a.* from (select * from zjfx_book_mark order by to_number(id) ) a where rownum <= 20) where num > 10 MySQL：select d.* from (select cast(@ROW :=@ROW + 1 as SIGNED) AS NUM,c.* from (select b.* from

--1:无ORDER BY排序的写法。(效率最高)--(经过测试，此方法成本最低，只嵌套一层，速度最快！即使查询的数据量再大，也几乎不受影响，速度依然！)SELECT*FROM(SELECTROWNUMASrowno,t.*FROMtemp tWHEREhire_dateBETWEENTO_DATE('201912...