SQL Server to select the specified range of lines in the code _mssql

In the database query, we sometimes have such a requirement, is to find the data table specified range of data records, such as to find the data table 10th to the 20th row of these 10 data, then how do we achieve it?

In the usual way, we have to use a temporary table and a function to implement


The code is as follows:


Select no=identity (int,1,1), * into #temptable from Dbo.teacher_info order by teacher_name--generate a record ordinal with the Identity function


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


drop table #temptable-delete temporary tables when finished


So we have achieved our purpose.