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;
Which of the following code blocks will remove the rows where the value in column age is greater than 25 from the existi
-
- Site Admin
- Posts: 899559
- Joined: Mon Aug 02, 2021 8:13 am