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;

Answer: C

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments