On Wed, Aug 06, 2003 at 12:05:47 -0700, The Pennant Shop <[EMAIL PROTECTED]> 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; ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
