sql,SELECT * FROM (, SELECT ROW_NUMBER() OVER (ORDER BY id) AS rownum, *, FROM your_table,) AS temp_table,WHERE rownum BETWEEN start_row AND end_row;,
`,,start_row
和end_row
是你要查询的起始行和结束行。sql,SELECT * FROM (, SELECT ROW_NUMBER() OVER (ORDER BY id) AS rownum, *, FROM your_table,) AS temp_table,WHERE rownum BETWEEN start_row AND end_row;,
`,,start_row
和end_row
是你要查询的起始行和结束行。Powered By Z-BlogPHP 1.7.3
Copyright Your WebSite.Some Rights Reserved.