SQL Server运行下面的语句报错:
SELECT F_Id, F_Account, F_NickName FROM Sys_Log ORDER BY F_Id ASC OFFSET 10 ROWS FETCH NEXT 90 ROWS ONLY,SQL Server没有这种写法吗?
你这写法是oracle 数据库吧?sqlserver 分页用top
select top 90 id from Sys_Log
where id not in (
select top 10 id from Sys_Log order by F_Id
) order by F_Id
支持这样的写法,但有版本要求,2012+