如何从具有特定行号的表中删除或选择一行? [英] How can I delete or select a row from a table that has a specific row number?

问题描述

我有一个关于 Microsoft SQL Server 2005 的问题.如何从具有特定行号的表中删除或选择行?

I have a question about Microsoft SQL Server 2005. How can I delete or select a row from a table that has a specific row number?

推荐答案

修改代码，使其更符合 OP 的意图

Modified the code so that it matches more closely to OP's intentions

Declare @RowNum as INT
SET @RowNum = 15 ---Just for example

WITH OrdersRN AS
(
    SELECT ROW_NUMBER() OVER(ORDER BY OrderDate, OrderID) AS RowNum
          ,OrderID
          ,OrderDate
          ,CustomerID
          ,EmployeeID
      FROM dbo.Orders
)

SELECT * 
  FROM OrdersRN
 WHERE RowNum = @RowNum
 ORDER BY OrderDate
         ,OrderID;

这篇关于如何从具有特定行号的表中删除或选择一行?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！