Re: Select distinct question ... complicated

On Wed, Aug 06, 2003 at 12:05:47 -0700, The Pennant Shop <vicmogroup@yahoo.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;