Page 1 of 1

select distinct on one paticular column

Posted: Tue Apr 15, 2008 1:25 pm
by GeXus
I have a situation where I'm tracking clicks, I want to be able to report on unique clicks (Based on unique ip address) and total clicks.

I would imagine this would be a matter of selecting distinct ip address, but how do I do that without having the other select columns be distinct?

Re: select distinct on one paticular column

Posted: Tue Apr 15, 2008 2:10 pm
by John Cartwright

Code: Select all

SELECT ... GROUP BY `ip`