Change Password

How does the SQL MERGE statement work, and in what scenarios is it commonly used?
MERGE is used for data encryption
MERGE is used to synchronize data between two tables based on a specified condition
MERGE is used for joining multiple tables
MERGE is only applicable to NoSQL databases