返回数据库表中第m到n条记录集的sql语句的两种写法

取第m—n条记录

第一种:

select top (n-m+1) * from users where username not in

(select top (m-1) username from users order by username) order by username

 第二种:

select * from
(select *, ROW_NUMBER() over (order by username) as row_number from users)as temp
where temp.row_number>=m and temp.row_number<=n

注: 第二种在SQL Server 2005中才适用.