如何动态更新前n行? [英] How to update top n rows dynamically?

问题描述

我的桌子上有相似的行...就像

I have a table with similar rows...like

PartNo  SerialNo  Inven_Qty  Status
------  --------  ---------  ------
001A    NULL      1          IN
001A    NULL      1          IN
001A    NULL      1          IN
001A    NULL      1          IN

现在，我想动态更新行..我有一个网页，我在其中输入PartNo，并且项目的值是OUT ... ex 2个项目是OUT ...我想用Inven_Qty 0更新2行以及状态为OUT....任何人都可以告诉我该怎么做吗?

Now I want to update the rows dynamically..I have a web page where I enter PartNo and the value of items which are OUT...ex 2 items are OUT...I want to update 2 rows with Inven_Qty 0 and status as OUT....Can anyone please tell me how to do this???

谢谢.

推荐答案

基于Mikael Eriksson，适用于Oracle:

Based on Mikael Eriksson, for Oracle:

update YourTable
  set Inven_Qty = 0,
      Status = 'OUT'
where PartNo = '001A'
  and Status = 'IN'
  and rownum<=3

(要更新3个项目)

这篇关于如何动态更新前n行?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！