Selact id, view_id,count(*) as kac_tane_var 
from table group by (id, view_id)
having count(*)> 1
birden fazla tekrarlari getirir