Answer-first summary for fast verification
Answer: MERGE INTO table_name
The `MERGE INTO` command is designed to perform insert, update, or delete operations based on a condition that checks if a row exists. This is particularly useful for synchronizing two tables by inserting, updating, or deleting rows in a target table based on a source table. For more details, refer to the [Databricks documentation on MERGE INTO](https://docs.databricks.com/spark/latest/spark-sql/language-manual/delta-merge-into.html).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which SQL command is capable of inserting, updating, or deleting rows based on a condition that checks for the existence of a row(s)?
A
COPY INTO table_name
B
MERGE INTO table_name
C
UPDATE table_name
D
INSERT INTO OVERWRITE table_name
E
INSERT IF EXISTS table_name
No comments yet.