[求助]修改倒数第3行数据

上炕不脱鞋发布于 2007-05-24 09:58， 794 次点击

select top 1 Opid,Opname from ( select top 3 Opid,Opname from OpInfo order by Opid desc
) as a order by Opid asc

这个是查询出了倒数第三行数据，怎么把OpName修改成0啊？？

2 回复

bygg2007-05-24 13:02

update OpInfo set OpName='0' where Opid=(select top 1 Opid from ( select top 3 Opid from OpInfo order by Opid desc) as a order by Opid asc)

上炕不脱鞋2007-05-25 19:55

谢谢啦