Which of the following SQL command can be used to insert or update or delete rows based on a condition to check if a row(s) exists?

Which of the following SQL command can be used to insert or update or delete rows based on a condition to check if a row(s) exists?
A . MERGE INTO table_name
B. COPY INTO table_name
C. UPDATE table_name
D. INSERT INTO OVERWRITE table_name
E. INSERT IF EXISTS table_name

View Answer

Answer: A

Explanation:

here is the additional documentation for your review. https://docs.databricks.com/spark/latest/spark-sql/language-manual/delta-merge-into.html