Hey Guys,
sorry for crap title? - I'm building statistics for a site and I want to output goal percentages.
What Im trying to achieve is a query to: group all unique 'ips', return there max 'goal', and add up ip's based on there goal.
Have a look at: this picture. It shows what I've done and what its returned. Hopefully better to visualize.
Thanks.
Not sure if it would work, but you could try using the HAVING clause i.e.
SELECT COUNT ( DISTINCT IP ) HAVING MAX ( goal ) FROM ...
Again not sure if this will work, just might be worth giving it a go.
