• 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;

    Related posts:

    1. Number of rows
    2. Sql Joins
    3. Auto Increment id in Mysql
      MySql Questions, Regular level
      ,

    Write a comment