Explanation:
DELETE FROM ... WHERE removes rows satisfying the predicate and commits a new Delta table version. SELECT only reads data, and an UPDATE statement requires a SET clause. Option E deletes the opposite set of rows.
Which SQL statement removes rows where age is greater than 25 from the existing Delta table my_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;
No comments yet.