DELETE FROM CM_HANGHOA_DVCM WHERE HH_ID IN 
(SELECT HH_ID FROM CM_HANGHOA_DVCM
GROUP BY HH_ID
HAVING COUNT(*) >1)

INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000000014','DM0000000000015')
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000003507','DM0000000000015')
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112038','DM0000000000049')
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112039','DM0000000000049')
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112060','DM0000000000015')
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112068','DM0000000000050')
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112072','DM0000000000049')
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112088','DM0000000000003')
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112195','DM0000000000003')
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112202','DM0000000000003')
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112253','DM0000000000006')
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112263','DM0000000000005')
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112267','DM0000000000004')
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112275','DM0000000000004')
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112277','DM0000000000004')
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112280','DM0000000000004')
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112282','DM0000000000004')
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112283','DM0000000000004')
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112289','DM0000000000004')
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112295','DM0000000000008')
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112296','DM0000000000008')
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112297','DM0000000000008')
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112299','DM0000000000008')
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000000112302','DM0000000000008')
INSERT INTO CM_HANGHOA_DVCM VALUES ('HH0000001058474','DM0000000000049')