Using merge statement to insert update and delete data in tables sql

SQL MERGE statement is used to modify data in a target table based on data in a source table.