OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Re: !! Help with query: Where Date = MAX(Date)

From: Michael Dykman (michaeldykman.org)
Date: Fri Feb 04 2005 - 10:57:56 CST

On Fri, 2005-02-04 at 09:19, Graham Cossey wrote:
> Could someone please offer a little help.
>
> I have a table like:
>
> Year, Month, Start_date
> 2004 10 20041102
> 2004 11 20041203
> 2004 12 20050104
> 2005 01 20050204
> 2005 02 20050303
>
> I need to get the latest Year,Month for a given date, so for example today
> (20050204) I should retrieve 2005,01.
>
> As I'm using 4.0.20 I can't use subqueries so how can I create a query that
> does this?
>
> SELECT year, month
> FROM `dc_months`
> WHERE start_date = (SELECT MAX(start_date)
> from dc_months
> where start_date <= '20050204')
>
> Any help much appreciated
>
> Graham

I think this conveys the idea:

SELECT year, month
FROM `dc_months`
WHERE start_date <= '20050204' ORDER BY start_date DESC
LIMIT 1

--
 - michael dykman
 - michaeldykman.org

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql