MySQLÖÐTOPÓï¾äµÄÈ¡´úÓï¾älimit

from http://blog.csdn.net/flyingpig204/article/details/4195896

MySQLÖв»Ö§³ÖTOPÓï¾ä,¶øÔÚSQL Server ºÍ sybaseÖвÅÓÐЧ.

MySQLÖÐ

select * from tablename order by orderfield desc/asc limit position,counter；

position ָʾ´ÓÄÄÀ￪ʼ²éѯ，Èç¹ûÊÇ0ÔòÊÇ´ÓÍ·¿ªÊ¼，counter ±íʾ²éѯµÄ¸öÊý
È¡Ç°15Ìõ¼Ç¼：
select * from tablename order by orderfield desc/asc limit 0,15