select
ip, max(timestamp) from table
group
by ip;
-----Original Message-----
From: Johan Muller [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 02, 2003 10:45 AM
To: Multiple recipients of list ORACLE-L
Subject: Sql query : select max timestamp value from tableI have multiple timestamps values for single ip in a table, I need the max(timestamp) for each ip I select out.
example:
timestamp ip
2003-09-29 13:20:23 68.209.182.4
2003-09-29 13:20:44 68.209.182.4
2003-10-02 12:53:38 68.209.182.4
2003-10-02 12:35:06 68.75.94.158
2003-10-02 12:52:03 68.97.33.69Thus
select distinct ip, max(timestamp) from table
group by ip, timestamp;
returns every timestamp value per ip.
Any ideas on how to get only the max(timestamp) for each ip?