﻿UPDATE `bd_aneks_ok` SET `komintent`=7050 WHERE `komintent`=30;
UPDATE `bd_fakturi` SET `dokkupuv`=7050 WHERE `dokkupuv`=30;
UPDATE `bd_naplata` SET `komintent`=7050 WHERE `komintent`=30;
UPDATE `bd_polisa` SET `komintent`=7050 WHERE `komintent`=30;
UPDATE `bd_polisa` SET `osigurenik`=7050 WHERE `osigurenik`=30;

DELETE FROM `bd_kupuv` WHERE `komintent`=30;


SELECT komintent, dbr
 FROM bd_kupuv
 GROUP BY dbr
 HAVING count(dbr) > 1


SELECT *
 FROM bd_kupuv
 WHERE dbr IN (
    SELECT dbr
    FROM bd_kupuv
    GROUP BY dbr
    HAVING count(dbr) > 1
    )
 ORDER BY dbr


SELECT  m.*
 FROM    (
        SELECT  dbr
        FROM    bd_kupuv
        GROUP BY
                dbr
        HAVING  COUNT(*) > 1
        ) AS q
 JOIN    bd_kupuv AS m
 ON      m.dbr = q.dbr