mysql - SQL Server 2012 等效限制分页

Question

以下 MySQL Sql 查询在 SQL Server 2012 中的语法是什么:

select title,description,tags,post_date
  from myvids order by title desc 
   limit 0,20

引用:Use LIMIT to paginate results in MySQL query

我想将数据库更改为 SQL Server。

TIA

Answer 1

             /********* For SQL Server 2012 & Later *********/

select [title]
      ,[description]
      ,tags
      ,post_date
from myvids 
ORDER BY [title] OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY;