> Is this Ok and I have to re-write query as> vac=> select count(*) from test t2 where exists > ^^> (select t1.y from test t1 where t1.y = t2.x);> ^^^> to get correlated one ?
Yes