Sql分页查询

MySQL

//Limit
SELECT * FROM table LIMIT 5,10; // 查询行 6-15   
SELECT ... FROM ... WHERE ... ORDER BY ... LIMIT ...  

Sql SERVER

//ROW_NUMBER() OVER()方式
select * from (select *, ROW_NUMBER() OVER(Order by ArtistId ) AS RowId from ArtistModels) as b where RowId between 10 and 20 
---where RowId BETWEEN 当前页数-1*条数 and 页数*条数---     
//--top not in
select top 3 * from ArtistModels where ArtistId not in (select top 15 ArtistId from ArtistModels)
--where Id not in (select top 条数*页数  ArtistId  from ArtistModels)