delete from pagehost where id in
(
select id from
(
select ROW_NUMBER()over (partition by webhost order by id )tt,id from pagehost
)ph where tt>1
)
delete from pagehost where id in
(
select id from
(
select ROW_NUMBER()over (partition by webhost order by id )tt,id from pagehost
)ph where tt>1
)