Select the SQL statement code for a specified range of rows in SQL Server

When querying a database, we sometimes need to find data records in rows within a specified range in the data table. For example, we need to find the 10 data records between 10th rows and 20th rows in the data table, so how can we implement it?

The common method is not feasible. We need to implement it by using a temporary table and a function.

CodeAs follows:

Select No = identity (INT,), * into # temptable from DBO. teacher_info order by teacher_name -- use the identity function to generate the record serial number

Select * from # temptable where no> = 10 and no <20

Drop table # temptable -- delete a temporary table after use

In this way, we have achieved our goal.