You can if you use nested SQL statements

You can use UPDATE and SELECT clauses together, even if you don’t have nested SQL statements.

You can if you use WITH clause.

You can't