本文介绍了如何动态更新前n行?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我的桌子上有相似的行...就像
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行?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!