Re: Basic SELECT help

[Michael Dykman]

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.