在sql server中选择表的第n行 [英] Select nth row of a table in sql server

问题描述

先生，

我想选择我桌子的第n行。

喜欢第3排，第4排.......

Sir,
I want to select my nth row of my table.
like 3rd row,4th row.......

推荐答案

尝试：

Try:

WITH myTableWithRows AS (
    SELECT (ROW_NUMBER() OVER (ORDER BY myTable.SomeField)) as row,*
    FROM myTable)
SELECT * FROM myTableWithRows WHERE row = 3

你可以使用row_number函数。请参阅以下MSDN链接 ROW_NUMBER（Transact-SQL） [ ^ ]。

you can use row_number function. Refer to following MSDN link ROW_NUMBER (Transact-SQL)[^].

例如，选择第5行



SELECT TOP 1 T. * FROM

（SELECT TOP 5 * FROM DBT_Person ORDER BY AGE ASC）AS T

ORDER BY T.AGE DESC;

for example, to select 5th row

SELECT TOP 1 T.* FROM
(SELECT TOP 5 * FROM DBT_Person ORDER BY AGE ASC) AS T
ORDER BY T.AGE DESC;

这篇关于在sql server中选择表的第n行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！