Explanation:
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.
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.