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