Oracle分页查询语句转成mysql分页查询语句,急!
一路随新 2013-03-31 01:28:26 jsp中想要将oracle的分页查询转为mysql的分页查询语句,oracle的分页查询是这样的,select a.* from (select t.*,rownum as rowNumber from (#SELECTSQL) t where rownum <= ?) a where a.rowNumber >= ?
如果转到mysql的分页要如何转啊?另外#SELECTSQL代表什么意思,高手能帮我看下?谢谢了