You can group by item_sid (drop session_id and ip_number from group by clause) and then join with the parent table to get session_id and ip_number.
-Ajo On Mon, Feb 21, 2011 at 3:07 AM, Cam Bazz <camb...@gmail.com> wrote: > Hello, > > So I have table of item views with item_sid, ip_number, session_id > > I know it will not be that exact, but I want to get unique views per > item, and i will accept ip_number, session_id tuple as an unique view. > > when I want to query just item hits I say: select item_sid, count(*) > from item_raw group by item_sid; > > but if I say: > > select item_sid, count(*) from item_raw group by item_sid, ip_number, > session_id; > > it will give me duplicate item sids. > > how can I query per unique tuple of ip_number, session_id per item_sid? > > best regards, > c.b. >
