Q. What is the purpose of the MERGE statement in SQL?

A
Deletes data
B
Performs insert, update, or delete based on a match
C
Creates a table
D
Filters data
Solution:

MERGE performs insert, update, or delete operations on a target table based on a source table match.

Entri PDF Icon

Get Question Bank

Strengthen Your Practice with our comprehensive question bank.

Entri Contact Image

Get Expert Advice for Free: Register for Your Free Consultation Now!