HI,
If I understand your question, you need two queries:
select count(*) as count, ip, value from log group by ip
select count(*) as count, ip, value from log group by ip,value
that leads to the right direction! thanks! It shows me a the ips with
their values and how many times they are in the
Hi,
something, that gets quite near to what I want is:
select a.id, a.value, b.value
from test as a left join test as b on a.id=b.id
group by a.id, a.value having a.valueb.value;
It spits out the right data, but not the way I want...
++---+---+
| id | value | value |
Hi,
sometimes one has to have the feeling, that somebody wants to help to
get it done better! :) I think I got it:
select a.id, a.value from test as a left join test as b on a.id=b.id
where a.value b.value group by a.id,a.value;
Its good to check logtables!
Of course I would appreciate