blocks|key|1614033|text|启动SQL+SERVER+2005，您可以执行以下操作...|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1614034|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;|code-block|syntax|javascript|1614035|或者类似于2000及更低版本的内容...|1614036|SELECT+TOP+10+*+FROM+(SELECT+TOP+20+FROM+Table+ORDER+BY+Id)+ORDER+BY+Id+DESC|1614037|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Starting SQL SERVER 2005, you can do this...

<pre><code>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;
</code></pre>

or something like this for 2000 and below versions...

<pre><code>SELECT TOP 10 * FROM (SELECT TOP 20 FROM Table ORDER BY Id) ORDER BY Id DESC
</code></pre>

blocks|key|1399255|text|笨拙，但它会起作用的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1399256|SELECT+TOP+10+*+FROM+table+WHERE+id+NOT+IN+(SELECT+TOP+10+id+FROM+table+ORDER+BY+id)+FROM+table+ORDER+BY+id|code-block|syntax|javascript|1399257|MSSQL省略LIMIT子句是犯罪行为，IMO。你不应该做这种笨拙的变通方法。|1399258|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Clunky, but it'll work.

<pre><code>SELECT TOP 10 * FROM table WHERE id NOT IN (SELECT TOP 10 id FROM table ORDER BY id) FROM table ORDER BY id
</code></pre>

MSSQL's omission of a LIMIT clause is criminal, IMO. You shouldn't have to do this kind of kludgy workaround.

blocks|key|1614329|text|从SQL+SERVER+2012开始，您可以使用OFFSET+FETCH子句：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1614330|USE+AdventureWorks;
GO
SELECT+SalesOrderID,+OrderDate
FROM+Sales.SalesOrderHeader+
ORDER+BY+SalesOrderID
++++OFFSET+10+ROWS
++++FETCH+NEXT+10+ROWS+ONLY;
GO|code-block|syntax|javascript|1614331|http://msdn.microsoft.com/en-us/library/ms188385(v=sql.110).aspx|offset|length|1614332|当order+by不是唯一的时，这可能无法正常工作。|1614333|如果查询修改为ORDER+BY+OrderDate，则返回的结果集不是预期的结果集。|1614334|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|1S|0|0|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|W|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|X|8|@]|9|@$I|Y|J|Z|1|10]]|A|$]]|$1|K|3|L|5|6|7|11|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|12|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|13|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|H]]]]

Starting with SQL SERVER 2012, you can use the OFFSET FETCH Clause:
<pre><code>USE AdventureWorks;
GO
SELECT SalesOrderID, OrderDate
FROM Sales.SalesOrderHeader 
ORDER BY SalesOrderID
 OFFSET 10 ROWS
 FETCH NEXT 10 ROWS ONLY;
GO
</code></pre>
<a href="http://msdn.microsoft.com/en-us/library/ms188385(v=sql.110).aspx" rel="noreferrer">http://msdn.microsoft.com/en-us/library/ms188385(v=sql.110).aspx</a>
This may not work correctly when the order by is not unique.
If the query is modified to ORDER BY OrderDate, the result set returned is not as expected.

blocks|key|1399680|text|以下是我在MS+SQL+Server+2012中限制结果的方式：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1399681|SELECT+*+
FROM+table1
ORDER+BY+columnName
++OFFSET+10+ROWS+FETCH+NEXT+10+ROWS+ONLY|code-block|syntax|javascript|1399682|注意：OFFSET只能与ORDER+BY一起使用或与其串联使用。|offset|length|style|CODE|1399683|解释代码行OFFSET+xx+ROWS+FETCH+NEXT+yy+ROW+ONLY|1399684|xx是您希望从表中开始提取的记录/行号，即:如果表1中有40条记录，上面的代码将从第10行开始提取。|1399685|yy是要从表中提取的记录/行数。|1399686|在前面示例的基础上构建:如果表1有40条记录，并且您开始从第10行拉取下一组10条记录(yy)。这意味着，上面的代码将从表1的第10行到第20行拉取记录，从而拉取第10+-+20行。|1399687|有关OFFSET的更多信息，请查看链接|1399688|entityMap|0|LINK|mutability|MUTABLE|url|https://technet.microsoft.com/en-us/library/gg699618(v=sql.110).aspx^0|0|0|3|6|C|8|0|5|11|0|0|2|0|0|2|0|18|2|0|2|6|0|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|15|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|16|8|@$I|17|J|18|K|L]|$I|19|J|1A|K|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|1B|8|@$I|1C|J|1D|K|L]]|9|@]|A|$]]|$1|O|3|P|5|6|7|1E|8|@$I|1F|J|1G|K|L]]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1H|8|@$I|1I|J|1J|K|L]]|9|@]|A|$]]|$1|S|3|T|5|6|7|1K|8|@$I|1L|J|1M|K|L]]|9|@]|A|$]]|$1|U|3|V|5|6|7|1N|8|@]|9|@$I|1O|J|1P|1|1Q]]|A|$]]|$1|W|3|-4|5|6|7|1R|8|@]|9|@]|A|$]]]|X|$Y|$5|Z|10|11|A|$12|13]]]]

This is how I limit the results in MS SQL Server 2012:

<pre><code>SELECT * 
FROM table1
ORDER BY columnName
 OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY
</code></pre>

NOTE: <code>OFFSET</code> can only be used with or in tandem to <code>ORDER BY</code>.

To explain the code line <code>OFFSET xx ROWS FETCH NEXT yy ROW ONLY</code>

The <code>xx</code> is the record/row number you want to start pulling from in the table, i.e: If there are 40 records in table 1, the code above will start pulling from row 10.

The <code>yy</code> is the number of records/rows you want to pull from the table.

To build on the previous example: If table 1 has 40 records and you began pulling from row 10 and grab the NEXT set of 10 (<code>yy</code>). 
That would mean, the code above will pull the records from table 1 starting at row 10 and ending at 20. Thus pulling rows 10 - 20.

Check out the link for more info on <a href="https://technet.microsoft.com/en-us/library/gg699618(v=sql.110).aspx" rel="noreferrer">OFFSET</a>

blocks|key|1614170|text|这几乎是我在10月份提出的一个问题的复制品：Emulate+MySQL+LIMIT+clause+in+Microsoft+SQL+Server+2000|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1614171|如果您使用的是Microsoft+SQL+Server+2000，则没有好的解决方案。大多数人不得不使用IDENTITY主键在临时表中捕获查询结果。然后使用BETWEEN条件对主键列进行查询。|style|CODE|1614172|如果您使用的是Microsoft+SQL+Server2005或更高版本，则有一个ROW_NUMBER()函数，因此您可以获得相同的结果，但要避免使用临时表。|1614173|SELECT+t1.*
FROM+(
++++SELECT+ROW_NUMBER+OVER(ORDER+BY+id)+AS+row,+t1.*
++++FROM+(+...original+SQL+query...+)+t1
)+t2
WHERE+t2.row+BETWEEN+@offset%2B1+AND+@offset%2B@count;|code-block|syntax|javascript|1614174|您也可以将其编写为@Leon+Tayson的answer中所示的common+table+expression。|1614175|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/216673/emulate-mysql-limit-clause-in-microsoft-sql-server-2000|1|https://stackoverflow.com/questions/603724/how-to-implements-limit-with-microsoft-sql/603746#603746|2|http://msdn.microsoft.com/en-us/library/ms190766.aspx^0|M|1J|0|0|1G|8|26|7|0|15|C|0|0|M|6|1|W|N|2|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@$A|13|B|14|1|15]]|C|$]]|$1|D|3|E|5|6|7|16|8|@$A|17|B|18|F|G]|$A|19|B|1A|F|G]]|9|@]|C|$]]|$1|H|3|I|5|6|7|1B|8|@$A|1C|B|1D|F|G]]|9|@]|C|$]]|$1|J|3|K|5|L|7|1E|8|@]|9|@]|C|$M|N]]|$1|O|3|P|5|6|7|1F|8|@]|9|@$A|1G|B|1H|1|1I]|$A|1J|B|1K|1|1L]]|C|$]]|$1|Q|3|-4|5|6|7|1M|8|@]|9|@]|C|$]]]|R|$S|$5|T|U|V|C|$W|X]]|Y|$5|T|U|V|C|$W|Z]]|10|$5|T|U|V|C|$W|11]]]]

This is almost a duplicate of a question I asked in October:
<a href="https://stackoverflow.com/questions/216673/emulate-mysql-limit-clause-in-microsoft-sql-server-2000">Emulate MySQL LIMIT clause in Microsoft SQL Server 2000</a>

If you're using Microsoft SQL Server 2000, there is no good solution. Most people have to resort to capturing the result of the query in a temporary table with a <code>IDENTITY</code> primary key. Then query against the primary key column using a <code>BETWEEN</code> condition.

If you're using Microsoft SQL Server 2005 or later, you have a <code>ROW_NUMBER()</code> function, so you can get the same result but avoid the temporary table.

<pre><code>SELECT t1.*
FROM (
 SELECT ROW_NUMBER OVER(ORDER BY id) AS row, t1.*
 FROM ( ...original SQL query... ) t1
) t2
WHERE t2.row BETWEEN @offset+1 AND @offset+@count;
</code></pre>

You can also write this as a <a href="http://msdn.microsoft.com/en-us/library/ms190766.aspx" rel="nofollow noreferrer">common table expression</a> as shown in @Leon Tayson's <a href="https://stackoverflow.com/questions/603724/how-to-implements-limit-with-microsoft-sql/603746#603746">answer</a>.

blocks|key|1399451|text|SELECT++*
FROM++++(
++++++++SELECT++TOP+20
++++++++++++++++t.*,+ROW_NUMBER()+OVER+(ORDER+BY+field1)+AS+rn
++++++++FROM++++table1+t
++++++++ORDER+BY
++++++++++++++++field1
++++++++)+t
WHERE+++rn+>+10|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1399452|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>SELECT *
FROM (
 SELECT TOP 20
 t.*, ROW_NUMBER() OVER (ORDER BY field1) AS rn
 FROM table1 t
 ORDER BY
 field1
 ) t
WHERE rn &gt; 10
</code></pre>

blocks|key|1399524|text|从语法上讲，MySQL限制查询类似于：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1399525|SELECT+*+FROM+table+LIMIT+OFFSET,+ROW_COUNT|code-block|syntax|javascript|1399526|这可以转换为Microsoft+SQL+Server，如下所示|1399527|SELECT+*+FROM+
(
++++SELECT+TOP+#{OFFSET%2BROW_COUNT}+*,+ROW_NUMBER()+OVER+(ORDER+BY+(SELECT+1))+AS+rnum+
++++FROM+table
)+a
WHERE+rnum+>+OFFSET|1399528|现在您的查询select+*+from+table1+LIMIT+10,20将如下所示：|offset|length|style|CODE|1399529|SELECT+*+FROM+
(
++++SELECT+TOP+30+*,+ROW_NUMBER()+OVER+(ORDER+BY+(SELECT+1))+AS+rnum+
++++FROM+table1
)+a
WHERE+rnum+>+10+|1399530|entityMap^0|0|0|0|0|6|W|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|Y|8|@$M|Z|N|10|O|P]]|9|@]|A|$]]|$1|Q|3|R|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|S|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|T|$]]

Syntactically MySQL LIMIT query is something like this:

<pre><code>SELECT * FROM table LIMIT OFFSET, ROW_COUNT
</code></pre>

This can be translated into Microsoft SQL Server like

<pre><code>SELECT * FROM 
(
 SELECT TOP #{OFFSET+ROW_COUNT} *, ROW_NUMBER() OVER (ORDER BY (SELECT 1)) AS rnum 
 FROM table
) a
WHERE rnum &gt; OFFSET
</code></pre>

Now your query <code>select * from table1 LIMIT 10,20</code> will be like this:

<pre><code>SELECT * FROM 
(
 SELECT TOP 30 *, ROW_NUMBER() OVER (ORDER BY (SELECT 1)) AS rnum 
 FROM table1
) a
WHERE rnum &gt; 10 
</code></pre>

blocks|key|1613864|text|SELECT+TOP+10+*+FROM+table;|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1613865|等同于|unstyled|1613866|SELECT+*+FROM+table+LIMIT+0,10;|1613867|Here's+an+article+about+implementing+Limit+in+MsSQL这是一个很好的阅读，特别是评论。|offset|length|1613868|entityMap|0|LINK|mutability|MUTABLE|url|http://www.select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html^0|0|0|0|0|1F|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|V|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|W|8|@]|9|@]|A|$B|C]]|$1|I|3|J|5|F|7|X|8|@]|9|@$K|Y|L|Z|1|10]]|A|$]]|$1|M|3|-4|5|F|7|11|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]]]

<pre><code>SELECT TOP 10 * FROM table;
</code></pre>

Is the same as

<pre><code>SELECT * FROM table LIMIT 0,10;
</code></pre>

<a href="http://www.select-sql.com/mssql/how-to-make-limit-from-to-in-mssql-2005.html" rel="nofollow noreferrer">Here's an article about implementing Limit in MsSQL</a> Its a nice read, specially the comments.

blocks|key|1399822|text|一定要试试。在下面的查询中，您可以看到group+by、order+by、Skip+rows和limit+rows。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1399823|select+emp_no+,+sum(salary_amount)+from+emp_salary
Group+by+emp_no+
ORDER+BY+emp_no+
OFFSET+5+ROWS+++++++--+Skip+first+5+
FETCH+NEXT+10+ROWS+ONLY;+--+limit+to+retrieve+next+10+row+after+skiping+rows|code-block|syntax|javascript|1399824|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Must try. In below query, you can see group by, order by, Skip rows, and limit rows.

<pre><code>select emp_no , sum(salary_amount) from emp_salary
Group by emp_no 
ORDER BY emp_no 
OFFSET 5 ROWS -- Skip first 5 
FETCH NEXT 10 ROWS ONLY; -- limit to retrieve next 10 row after skiping rows
</code></pre>

blocks|key|1614204|text|这是一种可以在SQL2000中使用的多步骤方法。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1614205|--+Create+a+temp+table+to+hold+the+data
CREATE+TABLE+#foo(rowID+int+identity(1,+1),+myOtherColumns)

INSERT+INTO+#foo+(myColumns)+SELECT+myData+order+By+MyCriteria

Select+*+FROM+#foo+where+rowID+>+10|code-block|syntax|javascript|1614206|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This is a multi step approach that will work in SQL2000.

<pre><code>-- Create a temp table to hold the data
CREATE TABLE #foo(rowID int identity(1, 1), myOtherColumns)

INSERT INTO #foo (myColumns) SELECT myData order By MyCriteria

Select * FROM #foo where rowID &gt; 10
</code></pre>

blocks|key|1614269|text|SELECT+
++++*+
FROM+
++++(
++++++++SELECT+
++++++++++++top+20++++++++++++++--+($a)+number+of+records+to+show
++++++++++++*+
++++++++FROM
++++++++++++(
++++++++++++++++SELECT+
++++++++++++++++++++top+29++++++--+($b)+last+record+position
++++++++++++++++++++*+
++++++++++++++++FROM+
++++++++++++++++++++table+++++++--+replace+this+for+table+name+(i.e.+"Customer")
++++++++++++++++ORDER+BY+
++++++++++++++++++++2+ASC
++++++++++++)+AS+tbl1+
++++++++ORDER+BY+
++++++++++++2+DESC
++++)+AS+tbl2+
ORDER+BY+
++++2+ASC;

--+Examples:

--+Show+5+records+from+position+5:
--+$a+=+5;
--+$b+=+(5+%2B+5)+-+1
--+$b+=+9;

--+Show+10+records+from+position+4:
--+$a+=+10;
--+$b+=+(10+%2B+4)+-+1
--+$b+=+13;

--+To+calculate+$b:
--+$b+=+($a+%2B+position)+-+1

--+For+the+present+exercise+we+need+to:
--+Show+20+records+from+position+10:
--+$a+=+20;
--+$b+=+(20+%2B+10)+-+1
--+$b+=+29;|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1614270|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>SELECT 
 * 
FROM 
 (
 SELECT 
 top 20 -- ($a) number of records to show
 * 
 FROM
 (
 SELECT 
 top 29 -- ($b) last record position
 * 
 FROM 
 table -- replace this for table name (i.e. "Customer")
 ORDER BY 
 2 ASC
 ) AS tbl1 
 ORDER BY 
 2 DESC
 ) AS tbl2 
ORDER BY 
 2 ASC;

-- Examples:

-- Show 5 records from position 5:
-- $a = 5;
-- $b = (5 + 5) - 1
-- $b = 9;

-- Show 10 records from position 4:
-- $a = 10;
-- $b = (10 + 4) - 1
-- $b = 13;

-- To calculate $b:
-- $b = ($a + position) - 1

-- For the present exercise we need to:
-- Show 20 records from position 10:
-- $a = 20;
-- $b = (20 + 10) - 1
-- $b = 29;
</code></pre>

blocks|key|1399772|text|在SQL中，不存在LIMIT关键字。如果您只需要有限的行数，则应该使用类似于限制的TOP关键字。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1399773|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

In SQL there's no LIMIT keyword exists. If you only need a limited number of rows you should use a TOP keyword which is similar to a LIMIT.

blocks|key|1399949|text|简单的方法|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1399950|MYSQL：|1399951|SELECT+'filds'+FROM+'table'+WHERE+'where'+LIMIT+'offset','per_page'|code-block|syntax|javascript|1399952|MSSQL：|1399953|SELECT+'filds'+FROM+'table'+WHERE+'where'+ORDER+BY+'any'+OFFSET+'offset'+
ROWS+FETCH+NEXT+'per_page'+ROWS+ONLY|1399954|排序依据是必填项|1399955|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|T|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|U|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

Easy way

MYSQL:

<pre><code>SELECT 'filds' FROM 'table' WHERE 'where' LIMIT 'offset','per_page'
</code></pre>

MSSQL:

<pre><code>SELECT 'filds' FROM 'table' WHERE 'where' ORDER BY 'any' OFFSET 'offset' 
ROWS FETCH NEXT 'per_page' ROWS ONLY
</code></pre>

ORDER BY is mandatory

blocks|key|1614597|text|以下是获得结果的可能方法之一，希望这能有所帮助。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1614598|declare+@start+int
declare+@end+int
SET+@start+=+'5000';++--+0+,+5000+,
SET+@end+=+'10000';+--+5001,+10001
SELECT+*+FROM+(+
++SELECT+TABLE_NAME,TABLE_TYPE,+ROW_NUMBER()+OVER+(ORDER+BY+TABLE_NAME)+as+row+FROM+information_schema.tables
+)+a+WHERE+a.row+>+@start+and+a.row+<=+@end|code-block|syntax|javascript|1614599|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

One of the possible way to get result as below , hope this will help.

<pre><code>declare @start int
declare @end int
SET @start = '5000'; -- 0 , 5000 ,
SET @end = '10000'; -- 5001, 10001
SELECT * FROM ( 
 SELECT TABLE_NAME,TABLE_TYPE, ROW_NUMBER() OVER (ORDER BY TABLE_NAME) as row FROM information_schema.tables
 ) a WHERE a.row &gt; @start and a.row &lt;= @end
</code></pre>

blocks|key|1614096|text|如果我没记错(自从我涉足SQL+Server已经有一段时间了)，你也许可以使用这样的东西：(2005或更高)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1614097|SELECT
++++*
+++,ROW_NUMBER()+OVER(ORDER+BY+SomeFields)+AS+[RowNum]
FROM+SomeTable
WHERE+RowNum+BETWEEN+10+AND+20|code-block|syntax|javascript|1614098|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

If i remember correctly (it's been a while since i dabbed with SQL Server) you may be able to use something like this: (2005 and up)

<pre><code>SELECT
 *
 ,ROW_NUMBER() OVER(ORDER BY SomeFields) AS [RowNum]
FROM SomeTable
WHERE RowNum BETWEEN 10 AND 20
</code></pre>

I have this query with MySQL:
<pre><code>select * from table1 LIMIT 10,20
</code></pre>
How can I do this with SQL Server?

How to implement LIMIT with SQL Server?

我对MySQL有这样的查询：select * from table1 LIMIT 10,20如何使用SQL Server执行此操作？

问如何用SQL Server实现LIMIT？
EN

回答 15

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何用SQL Server实现LIMIT？EN

回答 15

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何用SQL Server实现LIMIT？
EN