Eliminare record con campi doppi

[dizionario]

prova questa

SELECT TOP 6 articoli.* FROM (SELECT MAX(AD_ID) AS MAXID FROM articoli WHERE campo2='1' GROUP BY campo7) AS T1 INNER JOIN articoli ON MAXID=AD_ID ORDER BY AD_ID DESC