sql - How to select and update in one query? -

i need return row:

.net[tablereturn] = select top(1) * [table] x = 0 order desc 

but @ same time need update it:

update [table] set x = 1 [id] = .net[tablereturn].[id] 

and need data of row

it possible in same query?

resolve this!

declare @id int; set @id = (select top(1) id [table] [x] = 0 order id desc);  select * [table] id = @id; update [table] set [x] = 20 id = @id; 

:d