Re: [SQL] get distinct + group by then filter

2009-12-18 Thread Ivan Sergio Borgonovo
On Fri, 18 Dec 2009 13:20:00 +0100 Filip RembiaƂkowski wrote: > 2009/12/17 Ivan Sergio Borgonovo > > > I've a web application and I'm trying to do some reporting on > > affiliate commission > > > > create table tracky_hit ( > > hitid serial, > > esid varchar(32), -- related to browser session

Re: [SQL] get distinct + group by then filter

2009-12-18 Thread Filip RembiaƂkowski
2009/12/17 Ivan Sergio Borgonovo > I've a web application and I'm trying to do some reporting on > affiliate commission > > create table tracky_hit ( > hitid serial, > esid varchar(32), -- related to browser session > track_time timestamp, > aid varchar(32), -- affiliate code > -- some other