If there is a table of ABC, ten million data, dozens of field, id primary key
To query on page 100 of the 1000 data, paging SQL how to write the most efficient, compatible with more than 2008 version,
All bosses have what plan?

CodePudding user response:

row_number