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
Sent: Friday, March 16, 2001 3:44 PM
Subject: Please help me finding a sql-statement
Hi,
it is quite easy, I thought, but I can´t find it...
there is a table, which is used as a simple "logging table", so there is
only
ip | value | time
ip is not unique, neither is value.
ip and value in
Hi,
it is quite easy, I thought, but I can´t find it...
there is a table, which is used as a simple "logging table", so there is
only
ip | value | time
ip is not unique, neither is value.
ip and value in different rows can have the same values but sometimes
they differ, that´s the point!
I want
