
Databricks Certified Data Engineer - Associate
Get started today
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)?
Which SQL command is capable of inserting, updating, or deleting rows based on a condition that checks for the existence of a row(s)?
Real Exam
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.