Given the data from table t1:This DELETE command is executed:DELETE FROM t1 ORDER BY b.a DESC LIMIT 2;Which set of rows will be deleted by the command?
A. (7,1) and (1,4)
B. (2,8) and (1,4)
C. (7,1) and (10,8)
D. (2,8) and (10,8)
Given the data from table t1:This DELETE command is executed:DELETE FROM t1 ORDER BY b.a DESC LIMIT 2;Which set of rows
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Given the data from table t1:This DELETE command is executed:DELETE FROM t1 ORDER BY b.a DESC LIMIT 2;Which set of rows
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!