SQL Server implements basic paging functionality

SQL Server implements basic paging functionality using not and SELECT top to split pages

Use wh_workshopinforsys--creates a temporary table select IDENTITY (int,1,1) as id,* into Mytablefrom dbo. pnlbaobiao--paging Query Select top *from mytablewhere ID not in (select top-ID from MyTable ORDER by ID) Order BY id--Delete Table Dr OP table MyTable

Since the original table does not have a sequence number, so we have to create a temporary table to store the table with the increment ordinal, and then the table paging operation, and finally delete the temporary table, so it may be inefficient, this is the most clear way of thinking, and for the table that has an ID, The query speed is still acceptable.
, table starting from 41

SQL Server implements basic paging functionality