update如何只更新記錄號最大的一條記錄

xm1984

我這樣寫
update tbl_a  set data= "hello"
where seq = (select  max(seq) from tbl_a);

這樣存在360的錯誤，不能使用臨時表，如何通過調整sql實現？

wenlq

-360    Cannot modify table or view used in subquery.

The UPDATE, INSERT, or DELETE statement uses data taken from the same table
in a subquery. This action is not allowed because of the danger of getting
into an endless loop. Select the input data into a temporary table first,
and then refer to the temporary table in the UPDATE or INSERT statement.

superzg

先找到SEQ最大的記錄，在修改不行嗎？