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?
select distinct on one paticular column
Moderator: General Moderators
- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact:
Re: select distinct on one paticular column
Code: Select all
SELECT ... GROUP BY `ip`