mysql ne znam, no eto kak bix go naprawil na T-SQL

select x,y, count(*)
into #temp
from tablica
group by x,y
having count(*)>1

select t.*
from tablica t, #temp a
where t.x=a.x
and t.y=a.y