sql-server - SQL Server 更新语句执行

Question

我只需要从顶部更新 2 行。

这里我使用的是更新语句

UPDATE orderDetails 
SET status = 56 
WHERE OrderID IN (SELECT TOP 2 orderID   
                  FROM orderDetails 
                  WHERE station = 701)

但它正在更新所有行，不考虑 select 语句中的“TOP 2”。

Answer 1

试试这个:

update top (2) orderDetails 
SET status=56 
WHERE ORDErID in (select orderID   FROM orderDetails WHERE station=701)

或者你可以这样尝试:

;with cte as
( 
select top 2 * 
from orderDetails 
WHERE station = 701
order by somecolumn    --You need to specify the column on which you will make order by
) 
update cte set status=56