Changing rows?

Can i change/comute rows with an sql command?
like
change rowX with rowY ?

 

why make 2 threads on the same thing? You cant move rows around using commands.

 

Can you explain a little more what you need to accomplish?

You can replace all the values in rowX with rowY. This wouldn't make much sense, since changing a row's key would have the same effect and would be much quicker.

 

using update commend.
that syntax:

update table_name
set column_name = expression
from table_name
where search_conditions