List:General Discussion« Previous MessageNext Message »
From:Morten Date:August 4 2006 7:49pm
Subject:Re: Tricky query
View as plain text  
>>
>>
> How about:
> SELECT DISTINCT `key`, COUNT(`key`) AS c
> FROM `table` WHERE `value` in (8,9,10)
> HAVING c=3;
> 

Clever! Thanks :-)

Thread
Tricky queryMorten4 Aug
  • Re: Tricky queryPeter Brawley4 Aug
    • Re: Tricky queryMorten4 Aug
  • Re: Tricky queryGerald L. Clark4 Aug
    • Re: Tricky queryMorten4 Aug
  • Re: Tricky queryGerald L. Clark4 Aug