Comparing two counts using subquery
990190Feb 10 2013 — edited Feb 10 2013Hi all,
Managed to confuse myself significantly. I essentially want to write a query to determine when two counts are the same using a subquery.
Eg: R(x,y)
Select count(x)
from R
group by x;
Then I want to run another query to determine which x's have the same count value and output these corresponding x's.
Thanks!
//Mods: Sorry have moved this here. Please delete other thread as on reflection obviously in wrong section. Thanks