SELECT TOP 20 * FROM (SELECT
ROW_NUMBER() OVER (ORDER BY Namec) AS RowNumber,
*
FROM
dbo.mem_member) _myResults
WHERE
RowNumber > 10000
SELECT TOP 20 * FROM (SELECT
ROW_NUMBER() OVER (ORDER BY Namec) AS RowNumber,
*
FROM
dbo.mem_member) _myResults
WHERE
RowNumber > 10000
![【MySQL数据库】数据库索引事务1.索引2.事务[图]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)