在sql server中选择表的第n行

本文介绍了在sql server中选择表的第n行的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

先生， 我想选择我桌子的第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;