Equivalent Limit for SQL Server 2012 Pagination

Question

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

sql mysql sql-server pagination

Murali Bala 06 jan. 15 at 22:55

source to share

1 answer

M.Ali · Accepted Answer · 2015-01-06T23:01:58+0000

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

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

Equivalent Limit for SQL Server 2012 Pagination

More articles: