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 )
-
See also stackoverflow.com/questions/216673/…Bill Karwin– Bill Karwin2009-12-04 20:27:44 +00:00Commented Dec 4, 2009 at 20:27
-
Possible duplicate of How to implement LIMIT with Microsoft SQL Server?e4c5– e4c52016-12-17 05:18:50 +00:00Commented Dec 17, 2016 at 5:18
Add a comment
|
3 Answers
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
)
)
Comments
The closest to it is SELECT TOP X but it is only equivalent to LIMIT X.
For LIMIT X, Y, there is no direct MS-SQL equivalent (as far as I know). Christian's solution is a good one though.
MSSQL2005 (onwards) has the ROW_NUMBER syntax which might be useful:
http://msdn.microsoft.com/en-us/library/ms186734%28SQL.90%29.aspx
1 Comment
David Duman
I really wonder why microsoft doesnt add this feature into sql server?
cont=until desired number is starting to get results limit=Want to see how many variables
SELECT TOP (limit) cve_persona FROM persona WHERE (cve_persona > cont)
Comments
