Pergunta de entrevista da empresa Santander

In SQL how could you update a rows in one table by rows of the same table