How a merge statement work

Database
Enthusiast

How a merge statement work

Please help me understand how merge statement works instead of UPDATE/INSERT.