• Delete multiple duplicated rows

      0 comments
      15th Apr 10
      Bart

    How we can delete duplicate records of a table where it has no unique or primary keys?

    Mysql
    delete from table where x = ‘aaa’ limit 1;

    Mssql
    set rowcount 1;
    delete from table where x = ‘aaa’;
    set rowcount 0;

      MySql Questions, Regular level
      ,