祺祺妈妈

摘要： 用下面的语句就报语法出错：delete from tab_record where recordid not in (select min(c.recordid) as recordid from tab_record c group by (c.dev_Id+c.StartTime+c.EndTime+c.CardNum));报错如下：You can't specify target table '表名' for update in FROM clause找到替代方案，改用下面的，OK:delete from tab_record where recordid not 阅读全文