On Wed, Aug 06, 2003 at 12:05:47 -0700,
The Pennant Shop <vicmogroup(at)yahoo(dot)com> wrote:
> Hi ,
>
> I have a table:
> item location
> aaa 10
> aaa 20
> bbb 10
> bbb 10
> ccc 10
> ccc 20
>
> I need to select distinct items where locations are
> the same. So result set should look like:
> item loation
> bbb 10
> Already spent 7 hours on this one.
select item, location from table group by item, location having count(*) > 1;