sql,SELECT * FROM (, SELECT a.*, b.*, ROWNUM rnum, FROM table1 a, JOIN table2 b ON a.id = b.id, WHERE ROWNUM= :startRow;,
`,,在这个查询中,
:startRow和
:endRow`是分页的起始行和结束行参数。通过调整这两个参数,可以实现分页效果。Powered By Z-BlogPHP 1.7.3
Copyright Your WebSite.Some Rights Reserved.