mybaits对单表的嵌套子查询该怎么写呢？比如select id from A where id not in ( select id from A where id like "%a%" )

mybaits对单表的嵌套子查询该怎么写呢？比如select id from A where id not in ( select id from A where id like "%a%" )

你这不都写了出来吗？