如何使用Microsoft SQL Server实施LIMIT? [英] How to implement LIMIT with Microsoft SQL Server?
本文介绍了如何使用Microsoft SQL Server实施LIMIT?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我对mysql有此查询:
I have this query with mysql :
select * from table1 LIMIT 10,20
如何使用Microsoft sql执行此操作?
How can I do this with Microsoft sql ?
推荐答案
从SQL SERVER 2005开始,您可以执行此操作...
Starting SQL SERVER 2005, you can do this...
USE AdventureWorks;
GO
WITH OrderedOrders AS
(
SELECT SalesOrderID, OrderDate,
ROW_NUMBER() OVER (ORDER BY OrderDate) AS 'RowNumber'
FROM Sales.SalesOrderHeader
)
SELECT *
FROM OrderedOrders
WHERE RowNumber BETWEEN 10 AND 20;
或类似的东西(适用于2000年及以下版本)...
or something like this for 2000 and below versions...
SELECT TOP 10 * FROM (SELECT TOP 20 FROM Table ORDER BY Id) ORDER BY Id DESC
这篇关于如何使用Microsoft SQL Server实施LIMIT?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文