From: Dan Nelson
Date: June 16 2004 5:20pm
Subject: Re: Tough Query Problem
List-Archive: http://lists.mysql.com/mysql/167391
Message-Id: <20040616172017.GA2883@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Jun 16), Aaron Clausen said:
> I am trying to write a script that can take logs from our mail
> server, boil down the rejections to determine the sources of
> distributed SMTP dictionary attacks against our mail server.
> 
> Basically I have a table "send_failures like this that gets fed with
> the raw data from the logs:
> 
> host_ip			date
> -------------------------------------------
> 111.111.111.110		2004-06-03 13:42:22
> 
> And so on and so forth.
> 
> Now it's trivial to write a query to find the pure counting of the
> attacks: However, I also want to have latest date of the attack
> included as well, so that the above exampe would boil down to a query
> with results like this (I'm running MySQL 3.23.58):

Add "MAX(date) as last_attempt_date" to your select field list.

-- 
	Dan Nelson
	dnelson@stripped