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啊？？

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)

谢谢啦