SQL分页语句

写出一条Sql语句：取出表A中第31到第40记录（SQLServer,以自动增长的ID作为主键,注意：ID可能不是连续的。

1.--top+not in

select TOP 10 * from A WHERE ID NOT IN(SELECT  TOP 30 ID FROM A)

2.--row_number over+between and

select * from ( select ROW_NUMBER() over(order by ID asc) as row ,* from A) as atable

where row  between 1 and 10

linq语句分页

            var list= (from e in db.Musics select e).ToList();
            var reslist = list.Skip((page-1)*10).Take(limit).ToList();