update AdultTesto
set campo2=(
select top 1 T.campo2
from AdultTesto T
where T.campo15=AdultTesto.campo15
group by T.campo2
order by count(T.campo2) desc
)
where campo2='?'


UPDATE    AdultTesto
SET              Campo7 =
                          (SELECT     TOP 1 T.campo7
                            FROM          AdultTesto T
                            WHERE      T.campo15 = AdultTesto.campo15
                            GROUP BY T.campo7
                            ORDER BY COUNT(T.campo7) DESC)
WHERE     (Campo7 = '?')
