|
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: Philippe Poelvoorde (philippe
costrading.co.uk)
Date: Fri Feb 04 2005 - 08:37:08 CST
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
>
>
have a look here :
http://dev.mysql.com/doc/mysql/en/example-maximum-column-group-row.html
it should be useful for you.
--
Philippe Poelvoorde
COS Trading Ltd.
+44.(0)20.7376.2401
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]