From: Neil Tompkins
Date: November 22 2012 4:58pm
Subject: Re: Basic SELECT help
List-Archive: http://lists.mysql.com/mysql/228697
Message-Id: <CADa_cYrU9NomqW++n39y8RZiRHUUNk7EKeZYRhxgLMAt0hv6fg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=047d7b66f3c54311eb04cf1860e9

--047d7b66f3c54311eb04cf1860e9
Content-Type: text/plain; charset=ISO-8859-1

By unique you mean that no id and type would be duplicated like

1,1
1,1

Yes it isn't possible for duplicate id and type in more than 1 row


On Thu, Nov 22, 2012 at 4:46 PM, Michael Dykman <mdykman@stripped> wrote:

> Assuming that (id,type) is unique in the source data, that is a pretty
> elegant method:
>
> > select id from
> > (select distinct id, count(*)
> > from my_table
> > where type in (2,5)
> > group by id
> > having count(*) = 2)a;
> >
>
> --
>  - michael dykman
>  - mdykman@stripped
>
>  May the Source be with you.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>
>

--047d7b66f3c54311eb04cf1860e9--