DELETE * FROM LAVIE

SELECT
      DISTINCT(CONCAT(ART.ARTICLE_CODE, ART.COLOR_CODE))
    FROM
          (SELECT
              CONCAT(ART2.ARTICLE_CODE, ART2.COLOR_CODE
            , ROW_NUMBER ()
                OVER(PARTITION BY ART2.ARTICLE_CODE ORDER BY ART2.ARTICLE_CODE)
          FROM
              ARTICLE_COLOR_LOOKUP ART2
          WHERE
              RN > 1
          GROUP BY
              CONCAT(ART2.ARTICLE_CODE, ART2.COLOR_CODE)
          HAVING
            COUNT(CONCAT(ART2.ARTICLE_CODE, ART2.COLOR_CODE)) > 1);