二种sql分页查询语句分享

//第一种
select from
 (select ROW_NUMBER() over(order by Id asc) as num, from UserInfo)as u
 where u.num
 between
 10(4-1)+1
 and
 104
//第二种
select 10 from UserInfo
where Id not in
(select (103) id from UserInfo order by Id)
order by Id