Example of Output clause in SQL

The OUTPUT clause returns the values of each row that was affected by an INSERT, UPDATE or DELETE  statements.