What is the Equivalent syntax of mysql " LIMIT " clause in SQL Server

sql-server paging limit
Shyju picture Shyju · Nov 15, 2009 · Viewed 13k times · Source

What is the Equivalent syntax of MySQL " LIMIT " clause in SQL Server . I would like to use it for doing paging of my results. (want to show records5 to 10 )

Answer

Christian Payne picture Christian Payne · Nov 15, 2009

The closest thing is TOP:

Select top 5 * from tablename

You can get a range ( rows 5 - 10)

SELECT * FROM (
  SELECT TOP n * FROM (
    SELECT TOP z columns      -- (z=n+skip)
    FROM tablename
    ORDER BY key ASC
  )
)

Related questions

Select COUNT(*) of subquery without running it twice

I've got a procedure to return a result set which is limited by page number and some other stuff. As an OUTPUT parameter I need to return a total amount of selected rows according to the parameters except the page …

Read More
Return total records from SQL Server when using ROW_NUMBER

I would like to return the total number of records in the database so I can set up pagination. How do I return the total number of records in the DB when using the following paging method in SQL Server 2008? …

Read More
"Incorrect syntax near 'OFFSET'" modift sql comm 2012 to 2008

I'm listing questions with this SELECT q.qTitle, q.qDescription, q.qCreatedOn, u.uCode, u.uFullname, qcat.qcatTitle, q.qId, q.qStatus FROM tblQuestion AS q INNER JOIN tblUser AS u ON q.uId = u.uId INNER JOIN tblQuestionCategory AS …

Read More