Clever Geek Handbook

Equivalent Limit for SQL Server 2012 Pagination

What would be the SQL Server 2012 syntax for the following MySQL Sql query:

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

Ref: Use LIMIT for Pagination in MySQL Query

I want to change the database to SQL Server.

TIA

+3


source to share


1 answer 


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

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


+4


source






More articles:


All Articles