Johan,
First, you don't need the distinct. The proper query will return
1 row per ip. Second, take the max(timestamp) out of the group
by. That is causing the problem.
Daniel
Johan Muller wrote:
I have multiple timestamps values for single ip in a table, I
need the max(timestamp) for each
select ip, max(timestamp) from table
group by ip;
-Original Message-From: Johan Muller
[mailto:[EMAIL PROTECTED]Sent: Thursday, October 02, 2003 10:45
AMTo: Multiple recipients of list ORACLE-LSubject: Sql
query : select max timestamp value from table
I have multiple
Title: RE: Sql query : select max timestamp value from table
select ip, max(timestamp) from table
group by ip;
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original Message-
From: Johan Muller [SMTP:[EMAIL PROTECTED]
I have
Johann,
Take the timestamp out of your group by.
Cheers,
Melanie
***
Melanie Caffrey
Proximo Consulting
Services, Inc.
[EMAIL PROTECTED]
(212) 686-6004 Ext. 32
-Original Message-
From: [EMAIL
Title: Message
select
ip, max(timestamp) from table
group
by ip;
-Original Message-From: Johan Muller
[mailto:[EMAIL PROTECTED] Sent: Thursday, October 02, 2003 10:45
AMTo: Multiple recipients of list ORACLE-LSubject: Sql
query : select max timestamp value from table