Hi What I am trying to do is find all the _key_out which have a count of more than one, but they have to also have both source a and b within them, Below is a sample where I can get all the _key_out with a count greater than one but I cant get it to show only the _key_out which contain both source a and bAny help would be much appreciated, thanks. CREATE TABLE organisation( _key_out int, source nvarchar(50), ); INSERT INTO organisation (_key_out, source)VALUES (1,'A'),(1,'A'),(1,'A'),(2,'B'),(2,'B'),(3,'A'),(4,'B'),(4,'A'),(5,'A'),(6,'A'),(6,'B'),(7,'B'),(8,'A'),(8,'B'),(8,'A'),(9,'A'),(10,'A'),(10,'A'); SELECT _key_out, COUNT(*) FROM organisationGROUP BY _key_outHAVING COUNT(*) > 1
group by containing different fields
Posted - 2012-06-05 : 19:37:20
