推荐使用
select UserName from
(
select UserName, ROW_NUMBER() OVER ( order by UserName) as Pos from UserInfo
) as T
where T.Pos > 1 and T.Pos < 5
其他实现
取第11—20条记录
select top 10 * from users where username not in
( select top 10 username from users order by username) order by username
select UserName from
(
select UserName, ROW_NUMBER() OVER ( order by UserName) as Pos from UserInfo
) as T
where T.Pos > 1 and T.Pos < 5
其他实现
取第11—20条记录
select top 10 * from users where username not in
( select top 10 username from users order by username) order by username