Johann, Take the timestamp out of your group by. Cheers, Melanie ******************************************************************* Melanie Caffrey Proximo Consulting
Services, Inc. (212) 686-6004 Ext. 32 -----Original Message----- I 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 Thus 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? |
- Sql query : select max timestamp value from table Johan Muller
- Re: Sql query : select max timestamp value f... Daniel Fink
- RE: Sql query : select max timestamp value f... Khedr, Waleed
- RE: Sql query : select max timestamp value f... Whittle Jerome Contr NCI
- RE: Sql query : select max timestamp value f... Melanie Caffrey
- RE: Sql query : select max timestamp value f... Rothouse, Michael