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;
It´s good to check logtables!
Of course I would appreciate sugg
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.value<>b.value;
It spits out the right data, but not the way I want...
++---+---+
| id | value | value |
++--
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
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
- Original Message -
From: "Peter Holm" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 16, 2001
