求助 mysql 为什么不能直接删表内第 n 行？

delete from table where id = (select id from (select id from table order by id limit 1,1) as t)
好不容易google到了一个"trick"， 但完全不懂这句是在干吗。。delete套select再套select 楼主看晕了。。 试了一下貌似也没成功啊

貌似我已经成功了
上面的代码可以在sql删除第2行， 所以要是想删除第n行 就是
delete from table where id = (select id from (select id from table order by id limit n-1,1) as t)
google果然nb啊 @zgx030030 @a303743308