Which of the following code blocks will remove the rows where the value in column age is greater than 25 from the existing Delta table my_table and save the updated table?

Which of the following code blocks will remove the rows where the value in column age is greater than 25 from the existing Delta table my_table and save the updated table?
A . SELECT * FROM my_table WHERE age > 25;
B . UPDATE my_table WHERE age > 25;
C . DELETE FROM my_table WHERE age > 25;
D . UPDATE my_table WHERE age <= 25;
E . DELETE FROM my_table WHERE age <= 25;

View Answer

Answer: C