How to update the first row of a table in dolphindb?

Question

Does anyone know how to write the where conditions for the first row for dolphindb?

update table set x=100 where ?

user_11151749 · Answer

you can use the dolphindb function rowNo:

update t set x=100 where rowNo(x)=0